Hello everyone,
I have a question reguarding a small project im working on. I have weather data from our local stats site and it give me hourly data between jan 2010 to may 20 2011.
The file contains some data in a colum that looks like the following:
cloudy
cloudy and rainy
fog and rainy
fog
haze
cloudy and snow
clear
etc... (another several thousand lines)
Now what I would like to do is determine how many time something other then clear comes up. For example I would like to:
COUNTIF(A1:A50,OR("*rain*","*cloudy*",etc))
Now the above OR is not working, if i remove the OR and use a single criteria I get the proper result, but when i add the OR and another criteria as shown above i get 0 as a result. Notice that some lines of data contain both key words cloudy and rain so this is the reason i want to use the OR, i dont want to count both instances just one for that particular hour.
Please advise, thank you for your help.
Matt
Bookmarks