Excel If then Else function in Worksheet

[rajeevprabhuat]

Hi,

I am working on a worksheet and i am not able to get the correc
values in the worksheet. The formula that i have give is as follows:

SUM(IF('FIRST'!$E$8:$E$4987="PRODUCT"
IF('FIRST'!$P$8:$P$4987="ANALYSIS",1,0)))

In this Formula, "First" is a work sheet and in the that sheet w
are filtering cells under PRODUCT , and from those PRODUCT cells whic
has value ANALYSIS. But the final result that we are getting is no
correct "#Value#'. Can anyone help me in solving this problem.

Regard,
Rajeev Prabh

 

[Mangesh Yadav]

Enter the formula as an arrayformula. i.e. after entering the formula, press
control shift enter

Mangesh



"rajeevprabhuat"

 

[Biff]

Hi!

Try this instead:

=SUMPRODUCT(--(FIRST!$E$8:$E$4987="PRODUCT"),--(FIRST!$P$8:$P$4987="ANALYSIS"))

Even better:

A1 = Product
B1 = Analysis

=SUMPRODUCT(--(FIRST!$E$8:$E$4987=A1),--(FIRST!$P$8:$P$4987=B1))

Biff

"rajeevprabhuat"