View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wingman Wingman is offline
external usenet poster
 
Posts: 3
Default Counting cells with blank adjacent cell

Looking for a function to count the number of similar cells(Col A), but not
count them if the adjacent cell(Col B) has any text/numbers in it.

Col A Col B Col C
text1 2
text2 11/2 1
text1 2
text2 1

I log in tickets and need to know how many have not been paid.