SUM a range dependent on dates

Q

Qaspec

I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.
 
B

Bernard Liengme

To sum the values in D column when corresponding B values are equal or less
than TODAY
=SUMIF(D1:D30,"<="&TODAY(),B1:B30)
change D1 and B1 to D2 and B2 if row 1 had labels
best wishes
 

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

Need help with Excel Formula for calculating sum of products depending on criteria 3
Weigh tasks 0
SUMIF evaluating blank DATE data 2
Transpose 1
Index and Match 5
export data by selecting date range 5
Multiple IF Statement in Word 5
Countifs with if and date range 2

Top