total line item per day formula

[choybits]

Dears,

I have a spreadsheet that contains same sales orders. can you help me compute or sum the total line item per day

for example i want to know the total all the line items on december 1, 2017

[AliGW]

Try this:

=SUMIF($O$2:$O$33,X2,$P$2:$P$33)

[choybits]

It's working thank you for helping me

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.