Sum IF date < today

P

Price

I have two colomn. One has the date and the other has a $ amount. I
want to sum the $ amounts if the date in column 1 is less than today.
Assume that I have an infinite amount of rows in these columns.

Any assistance would be appreciated.
 
S

Steve

Assuming your data is in column A and B then in cell in any other column
other than A or B enter this:

=SUMIF(A:A,">" & TODAY(),B:B)

Steve.


Price wrote
 

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

Mail Merge Help 1
Use TODAY() function as the criteria in a SUMIF formula 1
Doughnut Chart linked with the slicer in the pivot table 0
Cumulative formula for word table 0
Visio Utilizing 100% Memory - Troubleshooting 0
Multiple IF Statement in Word 5
sum columns only if date 5
If Formula and Dates 4

Top