Sumif a number outside of the sum range is greater than zero

[Mike G.]

Hi everyone. I'm having a bit of trouble with my SUMIF formula. I'd like to sum N6-P6, only if the number inside cell M6 is greater than zero. If M6 is zero or blank then I'd like Q6 (where the formula is located) to return a zero?

Thank you in advance!

[Fluff13]

If you mean sum N6 to P6 rather than N6-P6. How about

Please Login or Register  to view this content.

[JohnTopley]

This ..???

=IF(N(M6)<>0,SUM(N6:P6),0)

[Mike G.]

Thanks so much Fluff13, it worked !!

[wk9128]

Try this formula

[Fluff13]

You're welcome & thanks for the feedback