Sep 25 2021 05:04 AM - edited Sep 25 2021 08:58 AM
I need my formula to add Tom's annual leave (Recorded in a different cells on different sheets with some empty spaces and different names but within always in column A).
The number of days are in column D.
From all my sheets I need to total the number of days taken for my Total Sheet.
Entered beside his name I need to drag this formula down so I can use it for all the other names on my total page as well.
Sep 25 2021 06:44 AM
Sep 25 2021 08:30 AM
@Ronan_321 Sheets go by months; column A goes by the Name of the Person; Column D is number of days taken.
How to I find the total number of days (COL. D) taken across a number of months(Sheets 1-7) and total it in my total page. I wish to do this for a number of people on the same list?
Col D where the names are have empty spaces in between names
Sep 26 2021 01:19 PM
SolutionFYI =SUMPRODUCT(SUMIF(INDIRECT("'"&$K$6:$K$8&"'!"&"A2:A10"),A4,INDIRECT("'"&$K$6:$K$8&"'!"&"D2:D10"))) @Ronan_321
Sep 26 2021 01:19 PM
SolutionFYI =SUMPRODUCT(SUMIF(INDIRECT("'"&$K$6:$K$8&"'!"&"A2:A10"),A4,INDIRECT("'"&$K$6:$K$8&"'!"&"D2:D10"))) @Ronan_321