| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thanks to everyone who replied. It all helped.
"Don Guillett" wrote: try =sumproduct((e2:e195629)*(e2:31956<40)) -- Don Guillett SalesAid Software "FinChase" wrote in message ... I am trying to write a countif statement where the criteria is a range of numbers from 30 - 39. This is what I've written: =countif(e2:e1956,"29<40") Right now it is counting everything over 29. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
| countif, dinamic criteria | Excel Worksheet Functions | |||
| How do I get the COUNTIF criteria to recognize only month and yea. | Excel Worksheet Functions | |||
Threaded Mode
