SUMIF

Nefarious

Nefarious

Nefarious

Associate
Joined
1 Aug 2003
Posts
1,053
I have two parallel rows, one with a value and the other with a yes/no validation.

Is it possible to perform a SUMIF or similar and have the sum of all the values with a YES beneath them and a sum of all the values with a NO beneath them?

Having done a bit of digging, DSUM looks like what I'm after, just having a bit of difficulty in working it out. Any suggestions would be helpful.
 
Last edited:
Think I may have solved this for you. If I understand you, you want/need two values? So a Yes and a No value depending on the values of the cells and whether they are a Yes or a No?

I've got two rows of data. Top row is just 1 - 10. Bottom row is Yes, No, Yes, No and so on.

If you're using Excel, then the 'Range' has to be the row of Yes/No. For the sum of Yes values, the criteria (criterion in this case) is simply 'Yes'. The 'Sum Range' is the row with the actual values you want summed. Hope this makes sense. I can send you my Excel spreadsheet I've worked on if you want.

:)
 
I'm nearly there!

The3 solution I've come up with so far is:

=SUMIF(C6:IV6,"Yes",C5:IV5)

But what do I put for infinity rather than just using a distant IV value for the column?
 
Nefarious said:
But what do I put for infinity rather than just using a distant IV value for the column?
Click to expand...
Huh?! :confused: You speaka de English yes?

Got Office 2000 here so if you've got something newer, I'm not seeing the same options for the SUMIF formula. Perhaps post a screeny or something?

Unless you mean, how do you get the formula to work for the entire row without you having to actually specify the row everytime you expand it?
 
You must log in or register to reply here.
Back
Top Bottom