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
SUMIFS, but from what I gathered, these can only operate on ranges, not on a another column per row.