Sep 06 2024 10:23 AM
I am trying to come with a formula that calculates the balance if two other critera are met. One is the name and the other is if the due date column has an entry that is late or not due yet. I have tried to follow examples of using a sumifs statement without success...any help would be greatly appreciated.
Sep 06 2024 11:41 AM
For Mikey:
=SUMIFS(Table3[Balance],Table3[Column1],"Mikey",Table3[Due Date],"<"&TODAY())
Sep 06 2024 12:01 PM
@HansVogelaar Thank you very, very much. The problem I had was not knowing where to place the quotation marks around the greater than or less than sign again, I really appreciate your help. You get 1 million stars.