Hi all.
First time posting here so be gentle! I have a new job a part of which is where I have to provide reports using data from excel 2003 sheets that are sent to me by someone else. I add my own formulas to get the data I need. One such bit of data is...
How many rows have "yes" in col E and "w" in range M:V?
I can do countif's for each individual query, ieA B C D E F G H I J K L M N O P Q R S T U V W X X X X X X X X X X X X X X X X X X X X A X X X X X X Y X X X X X X X X X X X X W X X X X X X X X X Y X X X X X X X X X X X X X A X X X X X X X X X X X X X X X X X X X X X X W X X X X X X X X X X X X X X X X X X X X X X W X X X X X X X X Y X X X X X X X X X X X X X X X A X X X X X X X X X X X X X X X X X X X X X X X A X X X X X Y X X X X X X X X X X X X X X W X X X
andcountif(E5:E400,"y*")
but how to pair the two together?countif(M5:V400,"w")
I have googled "nesting countif" and searched here, but I haven't understood the answers I have found. Doh!
I am a newbie to Excel and I did an internal 'basic' course last week. Can anyone help in plain English before I go back to work tommorrow please?
Many thanks.
Bookmarks