COUNTIF Question

[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/

 

[Arvi Laanemets]

Hi

=SUMPRODUCT((E2:E81="HPLJ4+")*(C2:C81="Yes"))
or
=SUMPRODUCT(--(E2:E81="HPLJ4+"),(--C2:C81="Yes"))

 

[duane]

can you insert a column F2:f81 =e2&c2 and copied down? then d
countif(f2:f81,"HPLJ4+yes"

 

[Frank Kabel]

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

 

[Arvi Laanemets]

Hi

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

You are right! Thanks!


Arvi Laanemets

 

[Israel Rodriguez]

Hi

=SUMPRODUCT((E2:E81="HPLJ4+")*(C2:C81="Yes"))

Thanks. It was just what I needed.

Israel Rodriguez

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