Count numbers formed from another formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm trying to count a set of #s that is formed by another formula. For
example, I have a list of numbers from c1-c6 which all have formulas in the
cell which creates that number. When I try to do functions counting the #s,
etc., it will not bring back a value. It doesn't want to count what has been
formed from another formula. Please help! Thanks!
 
Normally, COUNT(C1:C6) will count all of the values in column A, including
the zeros, but will ignore nulls ( "" )..............
Normally, COUNTA(C1:C6) will also include the nulls..........

What is your exact formula and what kind of a result/error are you getting?

Vaya con Dios,
Chuck, CABGx3
 
My bad...........should have read......

Normally, COUNT(C1:C6) will count all of the values in the range C1:C6,
including
the zeros, but will ignore nulls ( "" )..............
Normally, COUNTA(C1:C6) will also include the nulls..........

What is your exact formula and what kind of a result/error are you
getting?

Vaya con Dios,
Chuck, CABGx3


CLR said:
Normally, COUNT(C1:C6) will count all of the values in column A, including
the zeros, but will ignore nulls ( "" )..............
Normally, COUNTA(C1:C6) will also include the nulls..........

What is your exact formula and what kind of a result/error are you getting?

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Thanks for the reply!

I fixed it. I was using a complex array for what I wanted to do and then I
just saw you wrote a suggestion from a post I made on Saturday, and your
formula worked without any problem! Thanks.

CLR said:
My bad...........should have read......

Normally, COUNT(C1:C6) will count all of the values in the range C1:C6,
including
the zeros, but will ignore nulls ( "" )..............
Normally, COUNTA(C1:C6) will also include the nulls..........

What is your exact formula and what kind of a result/error are you
getting?

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Glad to be of help Stephen............thanks for the feedback.........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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 the columns from one sheet and paste it in another sheet 0
Excel Formula - Count Dates from another Sheet 8
Why doesn't excel count function update automatically? 1
Count to find the number of 100% 90% 80% in a column 7
Count until condition is met and then retain final count 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Need Countifs Formula Help 0
Count Number Of Times Values Appears Consecutively, Return Longest 5

Back
Top