Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel If then Else function in Worksheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
Excel shifts to wrong worksheet automatically | Excel Worksheet Functions | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions |