Are there any other numbers in the range besides 3 or -3? Can you post an
example of the data in the range and let us know what result you expect?

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
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!