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.

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.

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

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.