Formula Help Please

[Rubber Beaked Woodpecker]

Hi all

Column A displays the date in the following format 26/07/2024
Column X displays the number of hours worked for each date.

I would like a formula in cell Y1 to display the total number of hours worked for the last six days but I am unable to fathom this

Any help please RBW

 

[Joe4]

So much is dependent upon the structure of your data, it would be helpful to see it.

Is your data sorted by date?
If so, in ascending or descending order?

When you say you want the hours worked in the last 6 days, do you mean the last 6 entries, or just during the last 6 days (so there could be less than 6 entries)?

And how are your hours entered? Is just a regular number, or is it entered in a time format?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[etaf]

=SUMIFS(X2:X17,A2:A17,">="&TODAY()-6,A2:A17,"<="&TODAY())

Book8
	A	B																		T	U	V	W	X	Y
1																									56:00
2	7/22/24																							13:00
3	7/23/24																							9:00
4	7/24/24																							12:00
5	7/25/24																							13:00
6	7/26/24																							9:00	56:00
7	7/27/24																							12:00
8	7/28/24																							13:00
9	7/29/24																							9:00
10	7/30/24																							12:00
11	7/31/24																							13:00
12	8/1/24																							9:00
13	8/2/24																							12:00
14	8/3/24																							13:00
15	8/4/24																							9:00
16	8/5/24																							12:00
17	8/6/24
Sheet1

Cell Formulas
Range	Formula
Y1	Y1	=SUMIFS(X2:X17,A2:A17,">="&TODAY()-6,A2:A17,"<="&TODAY())
Y6	Y6	=SUM(X2:X6)

 

[Rubber Beaked Woodpecker]

=SUMIFS(X2:X17,A2:A17,">="&TODAY()-6,A2:A17,"<="&TODAY())

Book8
	A	B																		T	U	V	W	X	Y
1																									56:00
2	7/22/24																							13:00
3	7/23/24																							9:00
4	7/24/24																							12:00
5	7/25/24																							13:00
6	7/26/24																							9:00	56:00
7	7/27/24																							12:00
8	7/28/24																							13:00
9	7/29/24																							9:00
10	7/30/24																							12:00
11	7/31/24																							13:00
12	8/1/24																							9:00
13	8/2/24																							12:00
14	8/3/24																							13:00
15	8/4/24																							9:00
16	8/5/24																							12:00
17	8/6/24
Sheet1

Cell Formulas
Range	Formula
Y1	Y1	=SUMIFS(X2:X17,A2:A17,">="&TODAY()-6,A2:A17,"<="&TODAY())
Y6	Y6	=SUM(X2:X6)

Thank you works very well

 

[etaf]

you are welcome