| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting spefic cell (not a range) with a value greater than 1
I am looking for a formula to count specific cells and a range (A5, A10, A15,
A20 and so on) but only count when the value is greater than $1.00. So if the value of cell A5 was $1.50, the value of cell A10 was $1.25, the value of cell A15 was $0.50 and the value of cell A20 was $2.00 the total count would be 3. I'm stumped! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| Counting specific text in a cell | Excel Worksheet Functions | |||
| Searching text in a cell range | Excel Worksheet Functions | |||
| Counting instances in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
