Countif

[Steved]

Hello From Steved

=COUNTIF(E1:E900, "SL 202")

The above works as it should
I have an objective and that is to calculate the
sheet quick as posible with a Fast formula as the
above, but question I have a another Column with
the word "City",in it is it possible to to add this to
the above formula please. I've been working on formulas
for a while now and they fasinate me, in as much as not
putting in a to complicated formula that will take the
computer some time to calculate. In this case 8,000 rows.
Thankyou for taking timeout.

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--(E1:E900="SL 202"),--(F1:F900="City"))

 

[Steved]

Thankyou.

-----Original Message-----
Hi
try:
=SUMPRODUCT(--(E1:E900="SL 202"),--(F1:F900="City"))

.