I have two columns (state, date) I want to count if the state is anything but “closed” and the date is <today’s date. My results keep reading zero and I know it isn’t.
Thanks
I have two columns (state, date) I want to count if the state is anything but “closed” and the date is <today’s date. My results keep reading zero and I know it isn’t.
Thanks
And you're calculating your results how exactly ?
XL2003 - most likely SUMPRODUCT
use of TODAY makes the above Volatile obviously.Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi
this is the last one I tried. In this example I used a cell reference that contained todays date.
=SUMPRODUCT((Data!AK2:AK5000="")*(Data!O2:O5000<Z44))
Assuming you believe the result for the above should be something other than 0 what does the below return ?
Please Login or Register to view this content.
It returns 3030
If as implied my suggestion isn't working could you please post a sample file illustrating the problem ?
(obviously dummy any values that would be deemed confidential)
If you want to count how many states closed today use dcount function
see attached sheet
Regards
Hi,
I have attached part of the file. What I want to do is count how many records (rows) meet the following criteria: <> closed (State in col. CN) and is < than today's date (Due date in col. O).
Thanks
Your data gives zero because all of your due dates are greater then today
I have changed some dates and these are counted
see attached sheet
Criteria is in CS1 cell and answer in Cq1
Regards
Book1(3).xls
Last edited by mahju; 03-01-2011 at 06:53 AM. Reason: Attached file updated
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks