Help! 'SUMIF' Formulas

[dave1372]

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

[Catalin.B]

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

[dave1372]

Thanks for that, worked great.