Hi,

I am working on a worksheet and i am not able to get the correct
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 we
are filtering cells under PRODUCT , and from those PRODUCT cells which
has value ANALYSIS. But the final result that we are getting is not
correct "#Value#'. Can anyone help me in solving this problem.

Regard,
Rajeev Prabhu


--
rajeevprabhuat
------------------------------------------------------------------------
rajeevprabhuat's Profile: http://www.excelforum.com/member.php...o&userid=25380
View this thread: http://www.excelforum.com/showthread...hreadid=388579