Excel help

[Spogs]

I've been racking my brain to solve this problem and finally have to put my hands up and submit to the experts on bigfooty.

I have an excel column of figures that I need to add up if they satisfy 2 criteria. I have numbers in column C and I want to add them up if they match criteria in both column B and column D.

The data isn't in a format suitable for a pivot table.

SUMIF does half the job but only allows 1 condition. I'm sure there's a simple answer but I'll be stuffed if I can find it.

Would really appreciate any help.

 

[jim boy]

Originally posted by Spogs
I've been racking my brain to solve this problem and finally have to put my hands up and submit to the experts on bigfooty.

I have an excel column of figures that I need to add up if they satisfy 2 criteria. I have numbers in column C and I want to add them up if they match criteria in both column B and column D.

The data isn't in a format suitable for a pivot table.

SUMIF does half the job but only allows 1 condition. I'm sure there's a simple answer but I'll be stuffed if I can find it.

Would really appreciate any help.

You could always write 2 SUMIF statements within an IF statement, with the condition that the firsat SUMIF statement is greater than 0.

For example with IF(SUMIF(1st condition)>0,SUMIF(2nd condition)) Excel will check to to if the first SUMIF is valid and if so will execute the second SUMIF, thus giving you your SUM only if both SUMIF conditions are valid.

 

[Spogs]

Thanks Jim Boy,

I did try that but it wouldn't like the syntax so I assumed you couldn't use nested conditions for SUMIF. I'll try it again though.

Finally got around the problem using DSUM which is messy but allows any number of conditions.