Sumif with 2 criteria

  • Thread starter Thread starter Robert Christie
  • Start date Start date
R

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
 
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
 
You cannot reference entire columns. In addition, ensure you have double
opening and closing parentheses.
 
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
 
Back
Top