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.
Bookmarks