I have an issue having the correct summation for the ranges with xlookup or index+match formulas. the below screenshot , if you can see the total for the those values from 1-31, the correct answer when summed up is 47:26:59, it gives me an incorrect answer. Do you have any idea why?
this is what my formula from 1 to 31, referencing the column heading.
Please Login or Register to view this content.thanks in advance, i have attached an excel file for fast reference
Please Login or Register to view this content.