Problem with =sumifs

Copper Contributor

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.

2 Replies

@Donald6591 

For Mikey:

 

=SUMIFS(Table3[Balance],Table3[Column1],"Mikey",Table3[Due Date],"<"&TODAY())

@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.