View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott_goddard Scott_goddard is offline
external usenet poster
 
Posts: 32
Default Count If.....help

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.