Maxime Fleury
asked on
SumIF ?
Hi,
I want to sum the total hours from every sheets in my workbook referring to a certain code (code are in red in Parameter sheet). I'm nut sure SumIf the the right formula because you have to determine a certain zone.
Typical zone :
example Sheet E007n zone F14;I34 (same for every sheet)
Sheets can have different name.
Regards,
Maxime
Test.xls
I want to sum the total hours from every sheets in my workbook referring to a certain code (code are in red in Parameter sheet). I'm nut sure SumIf the the right formula because you have to determine a certain zone.
Typical zone :
example Sheet E007n zone F14;I34 (same for every sheet)
Sheets can have different name.
Regards,
Maxime
Test.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome! Glad I was able to help you this time :)
ASKER
I've used this with a macro that list all sheets that EE help me with a while ago.
Thanks!