|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (11 bit)
Join Date: Jun 2000
Location: Rochester, NY
Posts: 1,250
|
Hi,
I wanted to use the =countif but I don't know how to use it to single out a specific character in the data of a cell. Like I want to count the cells that have a monetary value in them and thought of using the $. How do you count just that and not the numbers and decimal points. Like if the cell contained $25.50 I just want to count the $. Can this be done? Also how do you count the number of cells in a range of cells and use that number to do a math function, like adding up a range of cells that contain money values then divide it by the number of cells to get an average. TIA
__________________
Greg 1- Gigabyte GA-P55A; i5-760 CPU; HSF XIGMATEK Gaia SD1283; 8 Gig Corsair XMS DDR 3 1600 Mem; HIS H577FK 1 GB Radeon 5770 VC; Linksys WRT54GL Router; SSD Intel X25-M 80 GIG; WD VelociRaptor 150 GIG; WD 6402AAEX HD; 2 LG SATA DVD Burners; PSU CORSAIR CMPSU-750TX 750W; Win 7 64 Bit; Acer 22" LCD Monitor |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|