Looking up a date and also a word for a sum function

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a range of cells in sheet 1 that has a place to
input dates in cells A1:A50. In cells B2:B50 there is a
list box with options to choose from and in cells C1:C50
there is a place to put the number of items received. On
sheet 2 I have in cells A2:A31 all the dates within the
month and in row B1:G1 there are the same options that are
in the list box on sheet 1 as column headings. In cell B2
on sheet 2 I would like a formula that will sum all of the
items received from C1:C50 if the date and option from the
list box match the date and column heading on sheet2.
Thanks for the help.

Todd
 
In cell B2, enter the formula:

=SUMPRODUCT((Sheet1!$A$1:$A$50=$A2)*(Sheet1!$B$1:$B$50=B$1)*(Sheet1!$C$1:$C$50))

Copy across to column G, and down to row 31.
 
Back
Top