Sum Numbers Linked to Dates After a Certain Date

[bjorng]

Hello,

I have a list of dates (A1:A100) and a corresponding cell (D1:D100) with a number. I want to sum all the numbers corresponding to the dates after a certain date in one cell. How do I do this?

Thank you,
Bjorn

[BadlySpelledBuoy]

Assuming the "certain date is in cell F1, try this formula:

=SUMIF(A1:A100,">"&F1,D1:D100)

Obviously change the F1 to the actual cell the date is in.

[bjorng]

Awesome, worked perfect! Thanks.

[BadlySpelledBuoy]

Glad I could help, Bjorn.

Don't forget to mark the thread as SOLVED if you're happy you have your solution.

BSB.