View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big UT Fan Big UT Fan is offline
external usenet poster
 
Posts: 34
Default Counting a row based on criteria in 2 cols

I need to count the cells in a worksheet where col B doesn't contain a
certain value and col L contains a different value. So...what I need to do
is count the rows where col B doesn't contain "Bear" and col L contains
"Goat". Your help is appreciated.