View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Loh Fred Loh is offline
external usenet poster
 
Posts: 3
Default countif criteria sg

thanks guys!

Gary's Student's solution works and the logic makes sense.

Teethless mama's solution also works but I don't understand why the need to
multiply {1,-1}

i can't get Don's solution to work. i have a "#NUM!" error.