Bahama85Copper ContributorSep 19, 2022SolvedTable Formula Hi All, Need help with a formula for tables. What u need on the sheet is to have on the "Time Off Earned" sheet is to have cell C2 withdrawal the sum of sheet "Time Off Requested" under Time Appr...Show MoredscheikeySep 19, 2022Bahama85 I have added some SUMIFS() functions to your table. Is that what you wanted?=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])
dscheikeySep 19, 2022Bahama85 I have added some SUMIFS() functions to your table. Is that what you wanted?=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])
dscheikeySep 19, 2022Bahama85 I have added some SUMIFS() functions to your table. Is that what you wanted?=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])
dscheikeyBronze ContributorSep 19, 2022Bahama85 I have added some SUMIFS() functions to your table. Is that what you wanted?=SUMIFS(Table1[Time Approved],Table1[Employee Name],[@Employee],Table1[Pay Code],Table4[[#Headers],[Personal Time]])
