Forum Discussion

Ronan_321's avatar
Ronan_321
Copper Contributor
Sep 25, 2021
Solved

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

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 c...
excel
Formulas and Functions
  • Ronan_321's avatar
    Ronan_321
    Sep 26, 2021

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

Ronan_321's avatar
Ronan_321
Copper Contributor
Sep 26, 2021

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