SOLVED

In Multiple sheets find Toms number of days taken and total them

%3CLINGO-SUB%20id%3D%22lingo-sub-2784563%22%20slang%3D%22en-US%22%3EFind%20name%20in%20column%20add%20the%20value%20in%20corresponding%20value%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784563%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20my%20formula%20to%20search%20through%20multiple%20sheets%2C%20find%20a%20name%20on%20different%20sheets%20in%20different%20places%2C%20through%20other%20names%20and%20blank%20spaces%20in%20my%20A%20column%20and%20go%20across%20to%20the%20total%20in%20column%20D%20and%20add%20all%20these%20totals%20in%20my%20totals%20page%20at%20the%20end%20for%20this%20name%3F%3F%3F%20Please%20and%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2784563%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2784678%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20name%20in%20column%20add%20the%20value%20in%20corresponding%20value%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784678%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20you%20give%20us%20more%20details.%20A%20sample%20data%20would%20be%20a%20good%20example%20so%20we%20can%20try%20to%20assist%20you%20accordingly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2784840%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20name%20in%20column%20add%20the%20value%20in%20corresponding%20value%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784840%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1166339%22%20target%3D%22_blank%22%3E%40Ronan_321%3C%2FA%3E%26nbsp%3BSheets%20go%20by%20months%3B%20column%20A%20goes%20by%20the%20Name%20of%20the%20Person%3B%20Column%20D%20is%20number%20of%20days%20taken.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20I%20find%20the%20total%20number%20of%20days%20(COL.%20D)%20taken%20across%20a%20number%20of%20months(Sheets%201-7)%20and%20total%20it%20in%20my%20total%20page.%20I%20wish%20to%20do%20this%20for%20a%20number%20of%20people%20on%20the%20same%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECol%20D%20where%20the%20names%20are%20have%20empty%20spaces%20in%20between%20names%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

 

3 Replies
I would suggest you give us more details. A sample data would be a good example so we can try to assist you accordingly.

@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 

 

best response confirmed by Ronan_321 (New Contributor)
Solution

FYI =SUMPRODUCT(SUMIF(INDIRECT("'"&$K$6:$K$8&"'!"&"A2:A10"),A4,INDIRECT("'"&$K$6:$K$8&"'!"&"D2:D10")))  @Ronan_321