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!

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!

A8 #n/a
A9 #n/a
A10 3
A11 -3
A12#n/a
A13 #n/a
A14 3
A15 3

result would be 3, since positive 3 occurred 3 times in the range and was the first non error result. 3 and -3 are only values aside from #N/A

---
frmsrcurl: http://msgroups.net/microsoft.public...non-error-cell

Hi,

Try this

=COUNTIF(E5:E13,INDEX(E5:E13,MATCH(TRUE,INDEX((ISN UMBER($E$5:$E$13)),,1),0),1)).
Please change the range references to A8:A15

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" / wrote in message
...
A8 #n/a
A9 #n/a
A10 3
A11 -3
A12#n/a
A13 #n/a
A14 3
A15 3

result would be 3, since positive 3 occurred 3 times in the range and was
the first non error result. 3 and -3 are only values aside from #N/A

---
frmsrcurl:
http://msgroups.net/microsoft.public...non-error-cell

=COUNTIF(E5:E13,INDEX(E5:E13,MATCH(TRUE,INDEX((IS NUMBER($E$5:$E$13)),,1),0),1))

If there are no numbers in the range that formula ends up counting how many
#N/A's are in the range.

Try this one:

=IF(COUNT(A8:A15),COUNTIF(A8:A15,INDEX(A8:A15,MATC H(1,INDEX(--ISNUMBER(A8:A15),0),0))),"")

--
Biff
Microsoft Excel MVP


"Ashish Mathur" wrote in message
...
Hi,

Try this

=COUNTIF(E5:E13,INDEX(E5:E13,MATCH(TRUE,INDEX((ISN UMBER($E$5:$E$13)),,1),0),1)).
Please change the range references to A8:A15

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" / wrote in message
...
A8 #n/a
A9 #n/a
A10 3
A11 -3
A12#n/a
A13 #n/a
A14 3
A15 3

result would be 3, since positive 3 occurred 3 times in the range and was
the first non error result. 3 and -3 are only values aside from #N/A

---
frmsrcurl:
http://msgroups.net/microsoft.public...non-error-cell

Thanks that does it!

---
frmsrcurl: http://msgroups.net/microsoft.public...non-error-cell

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"John" / wrote in message
...
Thanks that does it!

---
frmsrcurl:
http://msgroups.net/microsoft.public...non-error-cell