Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct #num error
I always have trouble setting up sumproduct functions.
I have a sheet called "diary". In column I, i have diary codes (505, 510, ect.). In column C, i have number codes that break down each diary code (1-8). I want to count how many of each number code, i have for each diary code. I'm using this function, but it returns an error. What am i doing wrong? =SUMPRODUCT((diary!I:I="510")+(diary!C:C="6")) |
#2
|
|||
|
|||
Dominique,
Try =SUMPRODUCT(--(diary!I1:I1000="510"),--(diary!C1:C1000="6")) SUMPRODUCT cannot work on complete columns. also, take a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html to get a better understanding of the function. -- HTH RP (remove nothere from the email address if mailing direct) "Dominique Feteau" wrote in message ... I always have trouble setting up sumproduct functions. I have a sheet called "diary". In column I, i have diary codes (505, 510, ect.). In column C, i have number codes that break down each diary code (1-8). I want to count how many of each number code, i have for each diary code. I'm using this function, but it returns an error. What am i doing wrong? =SUMPRODUCT((diary!I:I="510")+(diary!C:C="6")) |
#3
|
|||
|
|||
ooops...
i figured out my problem. cant use whole columns as an array. thanks anyway niq "Dominique Feteau" wrote in message ... I always have trouble setting up sumproduct functions. I have a sheet called "diary". In column I, i have diary codes (505, 510, ect.). In column C, i have number codes that break down each diary code (1-8). I want to count how many of each number code, i have for each diary code. I'm using this function, but it returns an error. What am i doing wrong? =SUMPRODUCT((diary!I:I="510")+(diary!C:C="6")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions | |||
#REF error | Excel Worksheet Functions |