I have an invoice tracker, and I'd like to use the sheet summary to indicate 2 different fields: "Total Paid" and "Total Due"
My columns are "Amount" and "Paid Date" "
For "Total Amount" I am using =SUM(Amount:Amount).
"Total Paid" - If a date is populated in the "Paid Date" column, calculate the the total sum from the "Amount" column.
"Total Due" - If the "Paid Date" column is left blank, calculate the the total sum from the "Amount" column.
Thank you ahead of time for your help!
Help Article Resources
Check out the Formula Handbook template!