| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells with two criteria
Ive got a spreadsheet that I need to find the number of cells in column G
that fit between two different criteria. The criteria are two numbers that may change in cell a2 and a3. So that if i change a2 or a3 i will get a new number in the cell with this formula. I dont need the numbers summed. Just the number of times the numbers fit. Thanks in advance. Chad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cells with two criteria
Try the following formula
=SUMPRODUCT(--(G1:G100=A2),--(G1:G100<=A3)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "USChad" wrote in message ... Ive got a spreadsheet that I need to find the number of cells in column G that fit between two different criteria. The criteria are two numbers that may change in cell a2 and a3. So that if i change a2 or a3 i will get a new number in the cell with this formula. I dont need the numbers summed. Just the number of times the numbers fit. Thanks in advance. Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| copying cells based on criteria | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
Linear Mode
