ssblue
asked on
Excel - i need to find totals based on dates
I would like to have the following formula show the totals if the date is in the past
=SUM(APJ6:APU6) / total for dates in the past
Also show the total it the date is in the future.
=SUM(APJ6:APU6) / total for current day and future dates
=SUM(APJ6:APU6) / total for dates in the past
Also show the total it the date is in the future.
=SUM(APJ6:APU6) / total for current day and future dates
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Which column has the dates and which column has the values to sum?
ASKER
That works but I'm going to have to ask another question, so stay tuned.
ASKER
Good question! I didn't think about that before I asked the question.