Hopefully someone can help, I am trying to find a way to use the SUMIF formulas to do this (if it makes sense, or am I using the wrong formula!)





What I want to do is use a formula to basically SUMIF in column A it says Qtr 1 and IF in column B it says Mr A, then sum the totals for Mr A .

ie Qtr 1 Income Total for Mr A = £30

I have spent 3hrs banging my head against the wall and I have given in to defeat!

Surely someone can make me feel and idiot and answer this in two seconds with an example formula please!

Cheers Dave

you need multiple ifs...
=SUMIFS($D$2:$D$16;B$2:B$16;1;C$2:C$16;"Mr A")

Attached Files

sample.xlsx (9.1 KB, 11 views)

Thanks for that, worked great.