Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to format cells having text and numeric | Excel Worksheet Functions | |||
Wildcard for finding the first numeric digit in a cell? | Excel Worksheet Functions | |||
Finding the mode (alpha numeric) | Excel Discussion (Misc queries) | |||
Is there a way to color the cells based on the numeric value? | Excel Worksheet Functions | |||
convert cells containing alpha to numeric | Excel Worksheet Functions |