Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Hello fom Steved
I have a worksheet named Bus Summary In Col A I have City In Col D I have 16-230 My Objective is how many 16-230 are in Col D. What is wrong please with my Formula. I have this Formula in a worksheet called Buses. =SUMPRODUCT(('Bus Summary'!$A$5:$A$2000="City")*('Bus Summary'!$D$5:$D$2000="16-230")*$D$5:$D$2000) Thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
I'm guessing here. If the 3rd range which references D5:D2000 is the same as
the 2nd range referencing D5:D2000, than it is not needed (assuming you are doing a count) and would cause the formula to fail because 16-230 is not a number. Try removing the 3rd range (you are doing a count, right?) -- Kevin Vaughn "Steved" wrote: Hello fom Steved I have a worksheet named Bus Summary In Col A I have City In Col D I have 16-230 My Objective is how many 16-230 are in Col D. What is wrong please with my Formula. I have this Formula in a worksheet called Buses. =SUMPRODUCT(('Bus Summary'!$A$5:$A$2000="City")*('Bus Summary'!$D$5:$D$2000="16-230")*$D$5:$D$2000) Thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
If you are just trying to count the number of times 16-230 appears, you don't need the second D5:D2000 range. =SUMPRODUCT(('Bus Summary'!$A$5:$A$2000="City")*('Bus Summary'!$D$5:$D$2000="16-230")) Should work for you. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=554747 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
I thankyou both.
"Steved" wrote: Hello fom Steved I have a worksheet named Bus Summary In Col A I have City In Col D I have 16-230 My Objective is how many 16-230 are in Col D. What is wrong please with my Formula. I have this Formula in a worksheet called Buses. =SUMPRODUCT(('Bus Summary'!$A$5:$A$2000="City")*('Bus Summary'!$D$5:$D$2000="16-230")*$D$5:$D$2000) Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | 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 |