Adding data to table daily and sum totals every 2 weeks

[northernwarrior]

ADDED ATTACHMENT with no Names

Hi,

I'm trying to figure this one out. I have a data set that I keep adding data and would like a formula to sum up a date range for each pay period in the year

My formula I use to sum up the hours is : =SUM(IF(dro!A:A='Top Sheet for Payment'!B3,dro!M:M,"")) but this is summing up all hours. Is there an adjustment I could use to just grab a date range ?

On the attachment, sheet "top sheet for payment" current has all days combined , and I left 2 columns blank to see if a new formula could be added.

If a pivot table is the easier option, how would I set the pivot table up to add the amounts for future dates with data ?

ie. here are the date ranges I need

Sept 10-23
Sept 24-Oct 7
Oct 8-21
Oct 22-Nov 4


Hopefully someone may be able to assist me in this.

BTW - the columns needed from the DRO Sheet are:

|Column A SAP - This is the person
Column D Date - The day
Column M Hours - for the day


Thanks in advance,

Ron

[Glenn Kennedy]

Simply shading a column black does not remove the names of the REAL people that you have identified. I do not know if the information is confidential or not... but to keep YOU safe, I have removed the attachment. Please repost WITHOUT real names.

[northernwarrior]

Simply shading a column black does not remove the names of the REAL people that you have identified. I do not know if the information is confidential or not... but to keep YOU safe, I have removed the attachment. Please repost WITHOUT real names.

Fixed :-)

Any chance you understand what I am trying to achieve ?

[JeteMc]

The dates in column D were text, using the Text to Columns feature they have been changed to dates.
The pivot table groups the Days (Date) column by days (14)
Let us know if you have any questions.