| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unable to grasp SUMPRODUCT
I have different sales offices in sheet1 column E E2 thru E8 I have revision numbers in sheet1 column I I2 thru I8 Data as follows E2=NF I2=emptycell E3=DP I3=40619 E4=DP I4=emptycell E5=NU I5=emptycell E6=DP I6=40609 E7=DP I7=emptycell E8=SF I8=40618 Sheet2 column A are my offices A2=DP A3=NU A4=SF A5=NF In sheet2 column c I need excel to enter a number to indicate how many times an office gets a revision number. Correct answers for above example should be DP=2 NU=0 SF=1 NF=0. But I cannot seem to get the formula right. I keep getting #NUM or # VALUE and so on. Would appreciate any help thank you. Todd -- toddbob ------------------------------------------------------------------------ toddbob's Profile: http://www.excelforum.com/member.php...o&userid=33112 View this thread: http://www.excelforum.com/showthread...hreadid=529773 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
