SUMIF

[Nefarious]

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.

 

[Nefarious]

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]

I mean, rather than giving the value for the row to sum as C5:IV5 whether I can specify the whole row excluding the first four cells.