Sumif fields have a positive number

[dawsonjj]

Why doesn't this work? =SUMIF(H6,">0")+(Q6,">0")+(Z6,">0")+(AI6,>0")+(AM6,">0"). I am wanting to sum the fields only if these numbers in these fields are positive. I would appreciate any help. They represent Overtime Hours. Thank you.

 

[Weazel]

probably not the most efficient way but maybe...

=SUM(SUMIF(INDIRECT({"H6","Q6","Z6","AI6","AM6"}),">0"))

 

[holystoner]

The only way to sum non contiguous ranges based on a criteria is to use the Indirect function (as above) or the chose function. Indirect is much cleaner.

 

[dawsonjj]

probably not the most efficient way but maybe...

=SUM(SUMIF(INDIRECT({"H6","Q6","Z6","AI6","AM6"}),">0"))

Thank you very much. It works great. Your help is greatly appreciated.