sumif nightmare!

[TamIam]

I was wondering if it's possible to use sumif with multiple criteria? In a
pivot table I have periods in a column with their corresponding values by
month in each row. In the left most column of the pivot table I have sorted
by revenue & expenses. I need to sumif (column d:d,"revenue" and column
e:e,"LY 2007", values in column f:f)

Sorry for the confusion!

 

[Marcelo]

Sumproduct will be better on this case

=sumproduct(--(a2:a100=a1)*(b2:b100=b2),(c2:c100))

just a sample, a1 and b1 has the conditonal

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"TamIam" escreveu:

 

[TamIam]

Did I do something wrong? I entered
=SUMPRODUCT(--(A6:A845="Revenue")*(D6845="LY 2007"),(E6:E845)) and the
formula didn't work. It gave me a value of -10 which is the value in cell E6?

Thanks again!

 

[TamIam]

No need to reply - it worked beautifully once I had my columns set up
properly! Thank you soooo much!