Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif with dynamic criteria
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. |
#2
|
|||
|
|||
Hi
two methods =COUNTIF(E2:E1956,""&29)-COUNTIF(E2:E1956,""&39) or =SUMPRODUCT(--(E2:E195629),--(E2:E1956<40)) Cheers JulieD "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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
=SUMPRODUCT(--(E2:A195629),--(E2:A1956<40))
or =COUNTIF(E2:A1956,"29")-COUNTIF(E2:A1956,"=40") -- HTH RP (remove nothere from the email address if mailing direct) "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. |
#5
|
|||
|
|||
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. |
Reply |
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 |