View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
walkerdayle walkerdayle is offline
external usenet poster
 
Posts: 1
Default Counting based upon 2 conditions that are text based



Hello everyone,
I'm trying to count data based upon two columns of data that are text
based. For example:
Column A Column B

- dog blue
- cat Brown
- cow Brown
- cow White
- cat Black

I'd like to know how I can count how many Cow's are brown. I'm sure
there's a nested CountIF statement in there somewhere.

Thanks for any help!
Anita


--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile: http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=573823