.. count all the z-6868 in column B that have a 6812 in Column A.
.. (answer 1)

Maybe something like this in say C1:
=SUMPRODUCT(($B$1:$B$2325="z-6868")*($A$1:$A$2325=6812))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tina" wrote:
Hello,
I am trying to count one column based on what another column has. I have
tried using a SUMPRODUCT and I either get a zero or the total amount. Can
someone help me?

This is what it looks like. There are several other columns but these are
the two columns I want to count. I would like to count all the z-6868 in
column B that have a 6812 in Column A. (answer 1)
Column A Column B
Row 1 6812 z-6868
Row 2 6868 z-6868
Row 3 6836 z-6868
When I use
=SUMPRODUCT((Sheet1'!$A$1:$AL$2325="Z-6868")--(sheet1'!$A$1:$AL$2325="6012"))+((sheet1'!$A$1:$AL $2325="W-6868")--(sheet1'!$A$1:$AL$2325="6012"))
value returned 3. Should be 1.

When I use
=SUMPRODUCT(('Sheet1'!$A$1:$AL$2325="Z-6868")*('Sheet1'!$A$1:$AL$2325="6012"))+(('Sheet1' !$A$1:$AL$2325="W-6868")*('Sheet1'!$A$1:$AL$2325="6012"))
the value returned is zero

I hope I was able to explain this right. Any help would be greatly
appreciated.

Thank you Tina