SUMIF Formula for Adding Multiple Lines With The Same Date

I am looking to create a summary sheet for daily productivity based that would feed from a separate data sheet. The data sheet has multiple lines with the same date on it. I have tried multiple formulas that are not working. I want to add the "# of pallets/pieces" with the same "appointment date" from my "BOC Receiving Scheduled Deliveries" sheet and have the total for that date reflect on my "Receiving Data" sheet. I have tried multiple SUMIF formulas and have received errors each time. Any help is appreciated!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!