Forum Discussion

Bahama85's avatar
Bahama85
Copper Contributor
Sep 19, 2022
Solved

Table 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...
  • dscheikey's avatar
    Sep 19, 2022

    Bahama85 

    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]])

     

Resources