COUNT multiple columns, numeric & text "URGENT"

[LIZZIE]

Thanks for any help.

With some help the other day, the following formula worked for one o
the items I was trying to accomplish: count how many in column A tha
are 0_F and are II in column K.

{=SUM((A1:A5="0_F")*(K1:K5="II"))}

A B K
0_F 1 I
0_F 2 II
0_F 1 II
0_R 1 II
0_R 2 I

The second item that I would like to count is how many in column B tha
are 2 and are II in column K.

I tried to use the same formula above, but it does not work. It give
me the answer 0 instead of 1.

Any suggestions?

Thanks in advance

 

[Bob Phillips]

Lizzie,

Don't put the 2 in quotes, leave it as numeric.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[mzehr]

Hi Lizzie,
Try
=SUMPRODUCT((B1:B5=2)*(K1:K5="II"))

HTH

 

[LIZZIE]

Thanks,

The sumproduct worked