Look up and sum data

%3CLINGO-SUB%20id%3D%22lingo-sub-1822452%22%20slang%3D%22en-US%22%3ELook%20up%20and%20sum%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822452%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20produce%20lookup%20data%20related%20to%20dates%2C%20and%20then%20want%20the%20formula%20to%20sum%20the%20data%20for%20multiple%20dates.%26nbsp%3B%20In%20other%20words%2C%20I%20have%20a%20table%20of%20dates%20and%20number%20of%20packages%20arriving.%26nbsp%3B%20However%2C%20the%20data%20has%20multiple%20dates.%26nbsp%3B%20For%20instance%2C%20there%20are%20three%20rows%20with%20the%20same%20date%2C%20and%20different%20values%20of%20packages%20for%20each%20date.%26nbsp%3B%20I%20want%20to%20lookup%20the%20number%20of%20packages%20for%20a%20date%2C%20and%20want%20the%20formula%20to%20look%20up%20the%20date%20and%20then%20sum%20the%20number%20of%20packages%20for%20each%20time%20the%20date%20repeats%20itself.%26nbsp%3B%20Hope%20I%20have%20made%20it%20clear.%26nbsp%3B%20See%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1822452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822505%22%20slang%3D%22en-US%22%3ERe%3A%20Look%20up%20and%20sum%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F847349%22%20target%3D%22_blank%22%3E%40Bashir2000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20I8%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUMIF(%24D%248%3A%24D%2413%2CH8%2C%24E%248%3A%24E%2413)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to produce lookup data related to dates, and then want the formula to sum the data for multiple dates.  In other words, I have a table of dates and number of packages arriving.  However, the data has multiple dates.  For instance, there are three rows with the same date, and different values of packages for each date.  I want to lookup the number of packages for a date, and want the formula to look up the date and then sum the number of packages for each time the date repeats itself.  Hope I have made it clear.  See attached file.

2 Replies

@Bashir2000 

In I8:

=SUMIF($D$8:$D$13,H8,$E$8:$E$13)

Fill down.

@Hans Vogelaar Thanks very much...I will try this solution...