Thread
:
SUMPRODUCT with date range question
View Single Post
#
2
Don Guillett
Posts: n/a
try something like this
=SUMPRODUCT((A7:A10="Y")*(B7:B10=TODAY())*(B7:B10 <=TODAY()+90)*C7:C10)-
Don Guillett
SalesAid Software
"Rob V" wrote in message
...
Hi all,
I'm having trouble creating a formula as follows:
Column A: either Y or N
Coumn B: a forecasted date
Column C: $$ amount of transaction
What I would like to do is create a report that shows the sum of column C
for anything where column A is "Y" and the date in column B is today's
date
or up to 90 days after today's date (Today +90)... I'm having problems
with
the date criteria, and would appreciate your help! Thanks
Reply With Quote