Dynamic Daily totals

[jra81882]

I have a workbook that tracks daily totals from 6 different time period throughout the day. I created a new page for totals. I used COUNTIF functions to count words for a given time period. Each day a new set of 6 columns are added for that given day. I need the totals to be locked to the given time periods. When ever new columns are added they shift down the sheet. Even attaching absolute cell references wont work. PLEASE HELP!

[JohnTopley]

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jra81882]

I just uploaded an example file

[JohnTopley]

See tab "Results_JT":

in B3

=SUMPRODUCT(--(INDEX(Overall!$A$4:$F$1000,,MATCH($A3,Overall!$A$3:$F$3,0))=B$2))

The data in A1 is "hard-coded": If you want this to be dynamic i.e, select different dates then the formula needs to be updated.

You can change it to TODAY() IF the the range A:F in OVERALL always contains TODAY()'s data.

Example of "Dynamic" formula .....

=SUMPRODUCT(--(INDEX(Overall!$4:$1000,,(MATCH($L$1,Overall!$2:$2,0)+MATCH($A3,Overall!$A$3:$F$3,0))-1)=M$2))

Highlighted range will need to be changed for each "table"

see table in L:U