SUMIF for variable cell range

P

Pantryman

Hallo Frank, Danke.

But the problem is that I first have to go back to the date closest t
today()-90,
then use that cell as a starting position for my SUMIF to do
subselection in that range for the types flown.
I can't figure that out, and don't know how to put your suggetion i
formula form.
Sorry, it's probably not very difficult but I don't see it.

could you suggest a formula?

Marinus
 
M

Myrna Larson

Can you be more specific re "closest"? Do you mean the minimum absolute
difference between the data and TODAY()-90, regardless of whether that date is
too early or too late? IOW, if you can't get exactly 90 days, do want to
increase the time span or shorten it?
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF for variable cell range 0
VLOOKUP or SUMIF for Multiple Criteria 2
Choose dat range for sumif formula 1
SUMIF for variable cell range 1
SUMIF data that falls within a range 3
SUMIF and text 3
Show value from one cell in another cell if today falls between a date range 5

Top