help with an COUNTIF formula

[kestrel]

hi all,

can someone give me a hand with a little problem i have in excel?

I am creating quite a few countif forumals, which are pretty easy.
What I want to do is count the data which has no data in the coloumn next to it.

example

Column A Column B
22 tea
33 coffee
tea
44 coffee
55 milk
66 sugar
tea

So if i was to do a countif for tea I want the results to be 2.

Any ideas?
thanks

[BenjieLop]

hi all,

can someone give me a hand with a little problem i have in excel?

I am creating quite a few countif forumals, which are pretty easy.
What I want to do is count the data which has no data in the coloumn next to it.

example

Column A Column B
22 tea
33 coffee
tea
44 coffee
55 milk
66 sugar
tea

So if i was to do a countif for tea I want the results to be 2.

Any ideas?
thanks

This is your formula ...

=sumproduct(--(B1:B7="tea),--(A1:A7=""))