If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SUMPRODUCT ISSUES
I am trying to get SUMPRODUCT to work and it is not.
Here is my data A L M 1 C 354.54 Notes about account 2 W 16.54 Blank (Null) 3 C 154.40 Notes about account 4 NE 1.50 Blank (Null) I am trying to get a total dollar amount (L) of all Regions (A) with notes on account (M) and without. Here is my formula: =SUMPRODUCT((Detail!$A2:$A12440 ="^C"),(Detail!$M2:$M12440 =""),(Detail!L2:L12440)) I am getting "0" now. If I play with the formula, change , to -- or *, then I get numbers, but they are not correct. Can you help? |
#2
|
|||
|
|||
SUMPRODUCT ISSUES
You have an answer here
http://www.microsoft.com/office/comm...b-1f04a7f273ec -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rbirdie" wrote: I am trying to get SUMPRODUCT to work and it is not. Here is my data A L M 1 C 354.54 Notes about account 2 W 16.54 Blank (Null) 3 C 154.40 Notes about account 4 NE 1.50 Blank (Null) I am trying to get a total dollar amount (L) of all Regions (A) with notes on account (M) and without. Here is my formula: =SUMPRODUCT((Detail!$A2:$A12440 ="^C"),(Detail!$M2:$M12440 =""),(Detail!L2:L12440)) I am getting "0" now. If I play with the formula, change , to -- or *, then I get numbers, but they are not correct. Can you help? |
#3
|
|||
|
|||
SUMPRODUCT ISSUES
Hi,
Try this =SUMPRODUCT((Detail!$A2:$A12440="C"),(Detail!$M2:$ M12440=""),(Detail!L2:L12440)) -- Regards, Ashish Mathur Microsoft Excel MVP "Rbirdie" wrote in message ... I am trying to get SUMPRODUCT to work and it is not. Here is my data A L M 1 C 354.54 Notes about account 2 W 16.54 Blank (Null) 3 C 154.40 Notes about account 4 NE 1.50 Blank (Null) I am trying to get a total dollar amount (L) of all Regions (A) with notes on account (M) and without. Here is my formula: =SUMPRODUCT((Detail!$A2:$A12440 ="^C"),(Detail!$M2:$M12440 =""),(Detail!L2:L12440)) I am getting "0" now. If I play with the formula, change , to -- or *, then I get numbers, but they are not correct. Can you help? |
Thread Tools | |
Display Modes | |
|
|