I have two columns:

  • Billing date : date
  • Billing amount : currency

I have another static cell where I want to sum all the Billing amount values, but only if the date in Billing date is greater or equal to now.

I have been looking into SUMIF and SUMIFS, but from what I gathered, these can only operate on ranges, not on a another column per row.


This worked:

=SUMIF(A:A, "<=" &TODAY(), C:C)

Where A is the date column and C is the amount column.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.