Formula To Sum Different Tables In Word For Mac

The following formula sums values in column D if a corresponding date in column C falls within the last 7 days including today.. If I call the bookmark test and use it in the same table that contains the value that Im referencing than the the code SUM test B2:B2 works but if I use it in other table it gives me this error: test Is Not In Table.. I want to be able to filter the table on the table worksheet and the results update in the SUM to be removed if they are hidden on the table.. Thanks again for helping me out and spending a lot of your time working on the code then on the variables afterwards.. I want to be able to filter the table in the table worksheet and remove the result update in SUM if they are hidden in the table. HERE

Thanks again for helping me and spending a lot of time working on the code so the variables after that.. If I call the bookmark test and use it in the same table that contains the value that in the reference range serves as the code SUM test B2: B2 but if I use it in another table it gives me this error message: Test is not in the table.. An equivalent date in column C falls in the last 7 days even today Sumifs can be used to evaluate values when neighboring cells meet criteria based on data numbers and text.. SUMIFS can be used to sum values when adjacent cells meet criteria based on dates numbers and text. Click

3

34bbb28f04 Click

HERE