View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default count if equals first non error cell

Hi, I want to count the number of times the number 3 or -3 comes up in A8:A15
depending on whether 3 or -3 comes up first. If 3 is A8 then count how many
times 3 is found in the range... if A8 is an error (#n/a) and A12 is the
first non error row and equals -3, count how many times -3 is in the origanal
range.

Thanks for the help!