=Sumproduct(--(B2:B1700="Site X"),--(N2:N1700=0)) will give you the count for
Site X with Number 0.

You can replace "Site X" by a cell address containing "Site X" and 0 by a
cell address containing 0.
So if you have unique SiteXNumber in X1:Y100 or whatever then you can enter
this in Z1
and copy down to get count for all combinaitons
=Sumproduct(--(B$2:B$1700=X1),--(N$2:N$1700=Y1))
--
If you find this post helpful pl. choose "Yes"...


"CMB" wrote:

I have multiple locations in column B ...B2:B1700 Site A, B, C, ...
In column N2:N1700 I have a number 0, 1, 2 3, 4 and so forth
Column B = Site X Column N= 0
Column B = Site X Column N= 0
Column B = Site X Column N= 1
Column B = Site U Column N= 4
Column B = Site U Column N= 1
I need to add the totals of Site X that equal 0, and Site X that equal 1
etc..
Site X has 3 0's, and Site X has 6, 1's ....
From this information I need to make a chart that shows the number per site
--
CMB