|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
unable to grasp SUMPRODUCT
for more information
http://xldynamic.com/source/xld.SUMPRODUCT.html
"toddbob" wrote:
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
|