COUNTIF Question

  • Thread starter Thread starter Israel Rodriguez
  • Start date Start date
I

Israel Rodriguez

I had set up a spead sheet that counted the different types of
pritners useda t my office.
for example, the cell counting this model of HP pritners has:
=COUNTIF(E2:E81,"HPLJ4+")

I wanted to set up soemthing that would count which of those printers
are network printers located on the floor as opposed to printers
located in offices, something like:
=COUNTIF(C2:C81,"Yes")
But with the results in the same cell, for example, how many of those
HPLJ4+ are network printers.

Can anyone help?


Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/
 
Hi

=SUMPRODUCT((E2:E81="HPLJ4+")*(C2:C81="Yes"))
or
=SUMPRODUCT(--(E2:E81="HPLJ4+"),(--C2:C81="Yes"))
 
Hi Arvi
i think for the second example you meant:
=SUMPRODUCT(--(E2:E81="HPLJ4+"),--(C2:C81="Yes"))

:-)
 
Hi


Frank Kabel said:
Hi Arvi
i think for the second example you meant:
=SUMPRODUCT(--(E2:E81="HPLJ4+"),--(C2:C81="Yes"))
Click to expand...


You are right! Thanks!


Arvi Laanemets
 
Back
Top