| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1
I have a range of values. I wish to count the number of values in this row
that are between 5 and 10.1. How do I do this? |
|
#2
|
|||
|
|||
|
try
=sumproduct((a2:a22=5)*(a2:a22<10.1)) -- Don Guillett SalesAid Software "John Higgins" <John wrote in message ... I have a range of values. I wish to count the number of values in this row that are between 5 and 10.1. How do I do this? |
|
#3
|
|||
|
|||
|
John
=COUNTIF(A1:T1,"5")-COUNTIF(A1:T1,"10.09999") for a range. OR =COUNTIF(1:1,"5")-COUNTIF(1:1,"10.09999") for entire row. Gord Dibben Excel MVP On Tue, 21 Dec 2004 17:01:02 -0800, John Higgins <John wrote: I have a range of values. I wish to count the number of values in this row that are between 5 and 10.1. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif, dinamic criteria | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
| countif, again | Excel Worksheet Functions | |||
Linear Mode
