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