Count if equal to first non error cell

J

John

Hi I tried to post this once so apologies if this is second post...

I want to count the number of times 3 or -3 occurs in range A8:A15 depending
on whether 3 or -3 comes first. If 3 is A8 then count how many times 3
occurs in the range. If A8 and A9 equal #n/a and A10 equals -3 then count
how many times -3 is in the range (there many be 2 -3's and one occurance of
a postive 3 for example)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count if equals first non error cell 6
function to use to count value 9
Count within a Range Q 10
Counting Unique occurences of text in a column 12
Complicated Formula 1
Count a Match set of values between cells 4
sumproduct exclude count 1
URGENT! how count how often a vlaue occurs within a range of value 3

Top