Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct
I need to count the number of items that have the designation of "R" (Column
A) and that also have a designation of "1" (Column B). I have tried several different formulas, but always get the return value of "0" (Zero). Formulas tried: =sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1")) ={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))} =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1")) Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct
You probably have the "1" entered as a number, not text. Thus, no need for
quotation marks. =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1)) Of note, you said columns A & B, but your formulas use G & T. I'm assuming you really meant the latter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Maureen" wrote: I need to count the number of items that have the designation of "R" (Column A) and that also have a designation of "1" (Column B). I have tried several different formulas, but always get the return value of "0" (Zero). Formulas tried: =sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1")) ={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))} =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1")) Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct
This should work
=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Maureen" wrote in message ... I need to count the number of items that have the designation of "R" (Column A) and that also have a designation of "1" (Column B). I have tried several different formulas, but always get the return value of "0" (Zero). Formulas tried: =sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1")) ={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))} =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1")) Any ideas? __________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct
if that value is really a number (not text), I'd try:
=sumproduct(--('Test Map'!G4:G126="R")),--('Test Map'!T4:T126=1)) Maureen wrote: I need to count the number of items that have the designation of "R" (Column A) and that also have a designation of "1" (Column B). I have tried several different formulas, but always get the return value of "0" (Zero). Formulas tried: =sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1")) ={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))} =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1")) Any ideas? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct
Thanks for the help; I will give these a try
"Bob Phillips" wrote: This should work =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Maureen" wrote in message ... I need to count the number of items that have the designation of "R" (Column A) and that also have a designation of "1" (Column B). I have tried several different formulas, but always get the return value of "0" (Zero). Formulas tried: =sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1")) ={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))} =SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1")) Any ideas? __________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct #Value! Problem | Excel Worksheet Functions | |||
Sumproduct Problem | Excel Worksheet Functions | |||
Problem using sumproduct | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Worksheet Functions |