Thread: Formula for variances

Hi,

My first time so please be gentle with me!

I need to work out a formula for a sumif (or sumproduct) for 3 variances. i.e.:

If column A = 2009 and column B = Gareth, sum the numbers in column C

Any suggestions please? I'm on Excel 2007.

Thanks,
Gareth

=SUMIFS(C1:C20,A1:A20,2009,B1:B20,"Gareth")

You're an absolute star. Thanks very much indeed. Works a treat.

G.