Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using count formulas with '<='
Ok, I have two columns first one (H3:H17) representing the date in which fees were paid for a tennis club and the second (K3:K17) representing when the fees are due (1/9/06) The 3 members who didn't pay their fees on or before the due date aren't considered 'current' members, I need to construct a formula which counts all the 'current' members. I beleive it would need to be a count formula using a date and counting if the date occurs prior to or on the due date. plz help, 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/14/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/17/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/9/06 1/10/06 1/9/06 -- Drummy ------------------------------------------------------------------------ Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780 View this thread: http://www.excelforum.com/showthread...hreadid=548468 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Count IF Multipile Formulas | New Users to Excel | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |