Excel If then Else function in Worksheet

R

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
 
M

Mangesh Yadav

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

Mangesh



"rajeevprabhuat"
 
B

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"
 
Top