Index/Array to pull all customers by a Month/Location column from Raw Data

[Miskondukt]

Greetings again all,

I am trying to get an index array or like formula to pull all the related rows of data from the "Raw Data" tab to drop into the "Summary Tab" of the attached sheet (which is a small part of a much larger file). I have been out of Excel for some six months and I am quite rusty on index/array.

On the "Summary Tab" I need to capture the customer data from the "Raw Data" per the summary's "Las Vegas" location cell that have values (Invoice Total) in the months noted in row 2 of same tab. Is this possible?

Thank you!

You can ignore the grand total values, I forgot to delete em.

[JohnTopley]

Try

=SUMIFS('Raw Data'!$AB:$AB,'Raw Data'!$C:$C,$D$1,'Raw Data'!$H:$H,">=" &B$2,'Raw Data'!$H:$H,"<=" &EOMONTH(B$2,0))

Set dates in B2:D2 as Excel date i.e 01/03/2016 (1 March) etc

[Miskondukt]

I will try, thank you. However, how can I automatically populate the customer column with those customers that have values for the corresponding column date month?

1. Needs to auto populate a customer list (Column A) of customers that had values in...
2. March
3. April
4. May
5. Then sumif the totals with your code

The key item is trying to auto-populate the customer list.