Count If.....help

[Scott_goddard]

I am trying to sum the amount of time two words "high" and "very high" appear
in a col....I can get this to work for one word but when i try and nest the
statement it doest work - Why and how to i solve it.

=COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks
Log'!L9:L99,"High"))

thanks.

 

[Duke Carey]

First, your question is ambiguous. Are you tring to count the number of
times a cell's contents - as a whole - is either "High" or "Very High"? Or
are you looking to count how many times the a) word or b) phrase appears
within other cell contents?

Second, COUNTIF() doesn't work the way you've tried to use it.

Since you're are using COUNTIF, let's assume the cells contain only High or
Very High. Just add two COUNTIF()s together

=COUNTIF('(R2) Risks Log'!L9:L99,"Very High") +CountIF(Risks
Log'!L9:L99,"High")

 

[Eduardo]

Hi,

=sumproduct(Risks Log'!L9:L99=,"Very High")*(Risks Log'!L9:L99=,"High")

 

[Don Guillett]

try using a wildcard

=COUNTIF('(R2) Risks Log'!L9:L99,"*High")

 

[Scott_goddard]

Sorry that doest work!! not sure why i also went down that route.

 

[Scott_goddard]

Didnt even think of doing this - very simple. thanks.

 

[Scott_goddard]

Sorry - i am trying to count the amount of time in a col the words "high and
"very high" appear. You formula works great - can you tell me why count IF
doesnt work like thay? and what should i have used?