SUMIF Function

  • Thread starter Thread starter joone
  • Start date Start date
J

joone

Need help on adding up numbers per day.
Here's what I got:
Sheet 1:
A1:A100=Dates
B1:B100=Destination
C1:C100=Number of Pieces

On a separate sheet, I want the total piece count daily
per destination. So it would look like this:
Note: I have over 20 destinations)
Sheet 2:
Row 1=Dates (Monthly)
A2:A25=Destination
The daily totals would be in the respective cells.

Thanks for the help.
 
Sounds like a job for a pivot tabl
DATES as ROW fiel
DESTINATION as COLUMN fiel
SUM of NUMBER OF PIECES as VALUE field
 
Back
Top