Sumif with 2 criteria

[Robert Christie]

Hi All
using WinXP & ExcelXP.
I have a sheet with 3 columns of date i.e.
Year Type Dollars
2003 W 10.00
2003 R 15.00
2003 R 19.00
2002 W 13.00
How can I sum the dollar costs using criteria of Year
2003 & Type W in the one formula.
Like IF(A:A,2003,If(B:B,"W"),SUM(C:C))
Tried SUMIF(AND(... & imbedded IF statements
but just can not get it right.

TIA
Bob C

 

[Ron]

Try using the Sumproduct function.

example: =sumproduct((A:A=2003)*(B:B="W")*(C:C))

Ron

 

[Robert Christie]

Hi Ron
Thankyou for your reply, I could not get it to work,just
get the #NUM! as answer. I got around the problem by
using a helper column with formula =A1&B1 and using the
normal SUMIF(H:H,"2003W",C:C)

Bob C

 

[Jim]

You cannot reference entire columns. In addition, ensure you have double
opening and closing parentheses.

 

[Robert Christie]

Hi Jim
To which post are you refering to; I don't quiet
understand your comments. My work around using a helper
column is working ok, whilst not what I originally wanted
to do.

TIA
Bob C