Count cell with ceveral logical questions?

[behedwin]

Hey

How can i with Excel formula do this:
1. First search a column for a specific value and count them. With this forumla
=ANTAL.OM(Blad1!A:A;"*SUSUS*")
(antal om = count if)

2. Now i want to take that search result and look for how many that have another value in another column.
So how many with SUSUS and have in another column "F"

So search in the result of the first formula.....

 

[steve the fish]

So you need two criteria? Its COUNTIFS rather than COUNTIF.

 

[AlanY]

do you have an equivalent countifs() function in your version of Excel?

 

[behedwin]

Ah, thats the one. Found it.
Thanks