SUMPRODUCT with date range question

G

Guest

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
 
D

Don Guillett

try something like this

=SUMPRODUCT((A7:A10="Y")*(B7:B10>=TODAY())*(B7:B10<=TODAY()+90)*C7:C10)-

Don Guillett
SalesAid Software
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct with multiple date criteria 1
sumproduct with date range 4
How to sum values between dates 4
Sum with multiple conditions - sumproduct, dsum or dproduct? 3
SUMPRODUCT to return date of last payment? 7
Sumproduct with nested if statement 5
Date Reformating Question 2
Formula Help 3

Top