View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
caddly caddly is offline
external usenet poster
 
Posts: 4
Default I hope someone can help me with a formula

I have a spreadsheet set up and need a formula to count the number of entries
in a row IF another row's criteria matches.
ie: COUNT(IF(B3:IV3,"Excellent"),IF(B1:IV1,"A07C,A06C, A18C)
The problem I'm encountering is that the 'count' formula does't seem to work
with multiple criteria...does anyone have any suggestions?