itipu
11-03-2009, 07:28 AM
Seemingly a very easy matter, but I can't seem to be able to resolve it...
All I need is to have a count of items that are "Column A - Target Date" 1 month overdue (today()-31) and have "Column B - Closed" as No....
I attached the spreadsheet to make it clear....
I tried a few things... closest I think is using SUM...
=SUM(IF(Tracker!A2:A10000<=TODAY(),0,1))*BLABLABLA
Trouble is.. if I specify range as A2:A10000 it counts all the blank cells and only works for greater than today (or today -31).. it does not work for less than as it assigns 1 to each blank cell to0 and of course.. A:A does not work either...
All I need is to have a count of items that are "Column A - Target Date" 1 month overdue (today()-31) and have "Column B - Closed" as No....
I attached the spreadsheet to make it clear....
I tried a few things... closest I think is using SUM...
=SUM(IF(Tracker!A2:A10000<=TODAY(),0,1))*BLABLABLA
Trouble is.. if I specify range as A2:A10000 it counts all the blank cells and only works for greater than today (or today -31).. it does not work for less than as it assigns 1 to each blank cell to0 and of course.. A:A does not work either...