finding only cells with a numeric value
 

Hi, i need to find a way to count the cells in a certain range that have a
numeric value. I want to make sure it doesn't count cells with text or cells
that are blank. I can get it to count without the blank cells, but i am
having trouble getting it to check for text vs numeric. Any help would be
appreciated.

EX of cells with data:

columns H-M rows 4 - 14

$16.48 $0.24 -$0.26 $17.58 $7.51 $4.25
$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24
-$74.15 -$38.30 $0.48 zero -$9.07 $47.30
-$20.94 -$7.14 $46.94 $9.29 -$81.43 -$49.00
-$4.08 $0.00 $47.30 $48.53 $55.61 fossil
-$23.70 $57.91 $53.25 $12.16 $17.84 $92.98
-$2.48 $71.78 -$5.67 -$17.66 $57.72
-$41.86 -$27.59 -$53.83 -$75.01 -$65.85 $43.66
-$73.84 $6.03 $20.18 -$35.53 $28.57 $83.61
$0.00 -$69.33 $26.18 -$20.30 $0.20 $0.00
-$8.25 $24.22 N/A $12.41 -$46.42
$59.52 $10.14 -$63.33 -$8.96 -$37.93 $53.88


The current formula i have generates a total of all cells that arn't blank,
but i need one to also remove cells with text from the count as well.

The formula I currently have is :
=COUNTIF(H4:M15,"<")

any help on modifing this formula would be appreciated.

Thanks
~Eelinla

finding only cells with a numeric value
 

Use the COUNT function. It counts *numbers only*

=COUNT(H4:M15)

$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24

That $O.OO looks like a TEXT entry so it wouldn't be counted.

Biff

"Eelinla" wrote in message
...
Hi, i need to find a way to count the cells in a certain range that have a
numeric value. I want to make sure it doesn't count cells with text or
cells
that are blank. I can get it to count without the blank cells, but i am
having trouble getting it to check for text vs numeric. Any help would be
appreciated.

EX of cells with data:

columns H-M rows 4 - 14

$16.48 $0.24 -$0.26 $17.58 $7.51 $4.25
$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24
-$74.15 -$38.30 $0.48 zero -$9.07 $47.30
-$20.94 -$7.14 $46.94 $9.29 -$81.43 -$49.00
-$4.08 $0.00 $47.30 $48.53 $55.61 fossil
-$23.70 $57.91 $53.25 $12.16 $17.84 $92.98
-$2.48 $71.78 -$5.67 -$17.66 $57.72
-$41.86 -$27.59 -$53.83 -$75.01 -$65.85 $43.66
-$73.84 $6.03 $20.18 -$35.53 $28.57 $83.61
$0.00 -$69.33 $26.18 -$20.30 $0.20 $0.00
-$8.25 $24.22 N/A $12.41 -$46.42
$59.52 $10.14 -$63.33 -$8.96 -$37.93 $53.88


The current formula i have generates a total of all cells that arn't
blank,
but i need one to also remove cells with text from the count as well.

The formula I currently have is :
=COUNTIF(H4:M15,"<")

any help on modifing this formula would be appreciated.

Thanks
~Eelinla

finding only cells with a numeric value
 

Thanks I was making it more difficult than I needed to.

"T. Valko" wrote:

Use the COUNT function. It counts *numbers only*

=COUNT(H4:M15)

$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24

That $O.OO looks like a TEXT entry so it wouldn't be counted.

Biff

"Eelinla" wrote in message
...
Hi, i need to find a way to count the cells in a certain range that have a
numeric value. I want to make sure it doesn't count cells with text or
cells
that are blank. I can get it to count without the blank cells, but i am
having trouble getting it to check for text vs numeric. Any help would be
appreciated.

EX of cells with data:

columns H-M rows 4 - 14

$16.48 $0.24 -$0.26 $17.58 $7.51 $4.25
$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24
-$74.15 -$38.30 $0.48 zero -$9.07 $47.30
-$20.94 -$7.14 $46.94 $9.29 -$81.43 -$49.00
-$4.08 $0.00 $47.30 $48.53 $55.61 fossil
-$23.70 $57.91 $53.25 $12.16 $17.84 $92.98
-$2.48 $71.78 -$5.67 -$17.66 $57.72
-$41.86 -$27.59 -$53.83 -$75.01 -$65.85 $43.66
-$73.84 $6.03 $20.18 -$35.53 $28.57 $83.61
$0.00 -$69.33 $26.18 -$20.30 $0.20 $0.00
-$8.25 $24.22 N/A $12.41 -$46.42
$59.52 $10.14 -$63.33 -$8.96 -$37.93 $53.88


The current formula i have generates a total of all cells that arn't
blank,
but i need one to also remove cells with text from the count as well.

The formula I currently have is :
=COUNTIF(H4:M15,"<")

any help on modifing this formula would be appreciated.

Thanks
~Eelinla

finding only cells with a numeric value
 

You're welcome. Thanks for the feedback!

Biff

"Eelinla" wrote in message
...
Thanks I was making it more difficult than I needed to.

"T. Valko" wrote:

Use the COUNT function. It counts *numbers only*

=COUNT(H4:M15)

$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24

That $O.OO looks like a TEXT entry so it wouldn't be counted.

Biff

"Eelinla" wrote in message
...
Hi, i need to find a way to count the cells in a certain range that
have a
numeric value. I want to make sure it doesn't count cells with text or
cells
that are blank. I can get it to count without the blank cells, but i am
having trouble getting it to check for text vs numeric. Any help would
be
appreciated.

EX of cells with data:

columns H-M rows 4 - 14

$16.48 $0.24 -$0.26 $17.58 $7.51 $4.25
$72.22 $64.04 -$31.74 $22.30 $O.OO -$45.24
-$74.15 -$38.30 $0.48 zero -$9.07 $47.30
-$20.94 -$7.14 $46.94 $9.29 -$81.43 -$49.00
-$4.08 $0.00 $47.30 $48.53 $55.61 fossil
-$23.70 $57.91 $53.25 $12.16 $17.84 $92.98
-$2.48 $71.78 -$5.67 -$17.66 $57.72
-$41.86 -$27.59 -$53.83 -$75.01 -$65.85 $43.66
-$73.84 $6.03 $20.18 -$35.53 $28.57 $83.61
$0.00 -$69.33 $26.18 -$20.30 $0.20 $0.00
-$8.25 $24.22 N/A $12.41 -$46.42
$59.52 $10.14 -$63.33 -$8.96 -$37.93 $53.88


The current formula i have generates a total of all cells that arn't
blank,
but i need one to also remove cells with text from the count as well.

The formula I currently have is :
=COUNTIF(H4:M15,"<")

any help on modifing this formula would be appreciated.

Thanks
~Eelinla