|  | Counting cells which have some numerical value... | | |
| | | Spin |  |
|  Posted: Wed Sep 03, 2008 1:51 pm Post subject: Counting cells which have some numerical value... |  |
Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is blank,
such that at the bottom of the column I will have a total count of all
non-blank cells?
--
Spin |
| |
| | | Dave Peterson | |
| | Posted: Wed Sep 03, 2008 2:00 pm Post subject: Re: Counting cells which have some numerical value... | |
=count()
will count all the cells with numbers
=counta()
will count all the cells with anything--including formulas that evaluate to ""
=countblank()
will count the number of blank cells--including the formulas that evaluate to ""
Spin wrote:
| Quote: |
Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is blank,
such that at the bottom of the column I will have a total count of all
non-blank cells?
--
Spin
|
--
Dave Peterson |
| |
| | | Rick Rothstein | |
| | Posted: Wed Sep 03, 2008 2:01 pm Post subject: Re: Counting cells which have some numerical value... | |
Assuming the cells you want to check run from A1 to A100...
=COUNT(A1:A100)
This will return the count of cells with numbers (or dates, since they are
floating point numbers underneath it all)... it won't count cells with
non-numbers in the (blank cells or cells with text in them).
--
Rick (MVP - Excel)
"Spin" <Spin@invalid.com> wrote in message
news:6i7q3vFpf1lmU1@mid.individual.net...
| Quote: | Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is
blank, such that at the bottom of the column I will have a total count of
all non-blank cells?
--
Spin
|
|
| |
| | | RagDyeR | |
| | Posted: Wed Sep 03, 2008 2:02 pm Post subject: Re: Counting cells which have some numerical value... | |
To count *only* numbers, meaning text and blank cells are excluded:
=COUNT(A1:A50)
If you want to *include* TEXT cells in the count, which also counts zero
length text ( "" ) blank appearing cells:
=COUNTA(A1:A50)
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Spin" <Spin@invalid.com> wrote in message
news:6i7q3vFpf1lmU1@mid.individual.net...
Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is blank,
such that at the bottom of the column I will have a total count of all
non-blank cells?
--
Spin |
| |
| | | Peo Sjoblom | |
| | Posted: Wed Sep 03, 2008 2:02 pm Post subject: Re: Counting cells which have some numerical value... | |
COUNTA counts all non blank cells including those that look blank with
formulas
COUNT count cells with numbers
COUNTBLANK count empty/blank cells except blanks from formulas
--
Regards,
Peo Sjoblom
"Spin" <Spin@invalid.com> wrote in message
news:6i7q3vFpf1lmU1@mid.individual.net...
| Quote: | Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is
blank, such that at the bottom of the column I will have a total count of
all non-blank cells?
--
Spin
|
|
| |
| | | Pete_UK | |
| | Posted: Wed Sep 03, 2008 4:05 pm Post subject: Re: Counting cells which have some numerical value... | |
You could try this:
=COUNTIF(A:A,">0")
Counts all cells in column A greater than zero (blanks being treated
as a zero in this case).
Hope this helps.
Pete
On Sep 3, 4:51 pm, "Spin" <S...@invalid.com> wrote:
| Quote: | Gurus,
In Excel, how do I "count" a value of a cell as "1" if it has a numerical
value inside (for example, 2.50), and count it as "0" if the cell is blank,
such that at the bottom of the column I will have a total count of all
non-blank cells?
--
Spin |
|
| |
|
|
