View Single Post
Old 06-29-2018, 05:30 PM
DeepPurple's Avatar
DeepPurple DeepPurple is offline
Join Date: Jun 2004
Posts: 4,302

Sumproduct becomes more useful than sumif when you want to start customizing the calculation.

Your original post wasn't clear on exactly what you meant. If you are summing up two ranges, just sum them. What is the condition you want to meet with the If part?

This works if you want to force an error when a field is 0 or missing

=sumproduct(range, range, 1/range).

If that doesn't give you what you need, post some ficticious data that demonstrates the input and your desired output.
Come on. Let's go space truckin'. Come on!
Reply With Quote
Page generated in 0.09961 seconds with 9 queries