View Single Post
  #6  
Old 06-29-2018, 06:30 PM
DeepPurple's Avatar
DeepPurple DeepPurple is offline
Member
 
Join Date: Jun 2004
Posts: 4,229
Default

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.17901 seconds with 9 queries