sumif nightmare!
 

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!
--
Thanks for your help!

sumif nightmare!
 

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:

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!
--
Thanks for your help!

sumif nightmare!
 

Did I do something wrong? I entered
=SUMPRODUCT(--(A6:A845="Revenue")*(D6:D845="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!
--



"Marcelo" wrote:

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:

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!
--
Thanks for your help!

sumif nightmare!
 

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


"Marcelo" wrote:

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:

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!
--
Thanks for your help!