SUMIF Formula where date is less than or equal to today's date

[Iain170]

Hi I am trying to calculate the actual amount of money that will have been paid. I currently use a simple SUMIF formula that looks for an invoice date in column c then sums up the totals in column b however the invoice dates in column c (I.e when Payment will be made) can be a future date and I do not want to count these as being paid (as they won't have been until the invoice date). I simply want to total the amount paid where the date paid is either today or before today's date.

Hope this makes sense I have attached an example of my data.

Thanks

[Phuocam]

Try this ...

=SUMIF(C2:C35,"<="&TODAY(),B2:B35)

[Iain170]

Try this ...

=SUMIF(C2:C35,"<="&TODAY(),B2:B35)

Many thanks for this - could I ask how I would also count the suppliers paid

[Phuocam]

Use COUNTIF:

=COUNTIF(C2:C35,"<="&TODAY())

[Iain170]

Thank you for your response

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.