SUMIF Formula for Adding Multiple Lines With The Same Date

mwerner_ww

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!!

David Tutwiler

Have you tried something like:

=SUMIF({Appointment Date}, Date@row, {# of Pallets/Pieces})

David Tutwiler

Have you tried something like:

=SUMIF({Appointment Date}, Date@row, {# of Pallets/Pieces})

mwerner_ww

@David Tutwiler that worked perfectly!! Thank you!!

David Tutwiler

Awesome! Glad to hear you got it working.