Need formula of sumifs to fill across depends upon Date header

[johnlara]

Dear expert

I have sheet Dashboard which contains data range across rows and column with header i want fill the formula. but i have to do manually select range depends upon column header value

i have N number of date values but in the master sheet but in the table range i have only 5 or 6 only with no format continuation


i want avoid manually add sumifs(sum_range has to move depends up on header of column in table and rawdata.

please find the attachment with formula.

[AlanY]

try this in G14, copy down and across

Please Login or Register  to view this content.

[johnlara]

Thanks Kudos to alany!! Solved

[AlanY]

Thanks Kudos to alany!! Solved

You're welcome
Glad that helped