Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif using two conditions
Hello.
I read all of the COUNTIF , AND threads but did not find a solution to my problem. - I have a column of dates on one worklsheet - I'm trying to do a countif when the date falls between 2 dates that I specify, something like COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no luck. Any assitance is welcome. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif using two conditions
Try SUMPRODUCT
Something like this (using unambiguous date range criteria): =SUMPRODUCT((Sheet1!A2:A10=--"15 May 2009")*(Sheet1!A2:A10<=--"21 May 2009")) should work fine for you. Adapt the ranges/criteria to suit. High five success by clicking the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "NWO" wrote: I read all of the COUNTIF , AND threads but did not find a solution to my problem. - I have a column of dates on one worklsheet - I'm trying to do a countif when the date falls between 2 dates that I specify, something like COUNTif(sheet1!A:A,"=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no luck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF using conditions | Excel Worksheet Functions | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
COUNTIF with two conditions | Excel Discussion (Misc queries) | |||
COUNTIF 2 conditions | Excel Worksheet Functions | |||
COUNTIF with two conditions | Excel Worksheet Functions |