Using Sum If for a given date

[hedgie]

I am having some difficulty getting this to work correctly. I have a spreadsheet that has columns that indicate various dates, the rows are for various customers, some of which might have multiple inputs on any date. I am looking to create a summary page where I can input a date and have the sum of each customer shown.

Currently I do this manually - if 12/31/17 is Column X, and the cusotmer name is on customerpage!A2 then my sum if equation looks like : =SUMIF(page1!B:B,'customerpage!A2',page1!X:X)

Instead I would like to look up the column fo the date and use indirect to make this dynamic based on the date chosen.

 

[etaf]

you could use a SUMIFS()
and combine both customer name and date range

SUMIFS( Range to Sum , range for customer name, customer name , range for dates , date)