Hi There,
I am trying to add 2 FX's that will take the data in the "Data" tab and paste it into the appropriate column based on the employee name, if it's a Day or Week stat, and if the checkmark is checked(as true) in the "Averages" tab.
I am assuming it's an If(and( FX with Index as the "IF TRUE" part but I am not too familiar with rows and can't seem to make it skip rows. When I do it, on the "averages" tab it shows the values in the "Data" tab but it skips rows based on how it's laid out in the "Averages" tab.
In the "Data" tab, in the columns listed as "Goal %," I will be putting employee Daily results. Every 5 days, the following portion will be the weekly average which has a formula in there. I want the values in the "Goal %" column to appear in the "Averages" tab split into the "Daily" and "Weekly" column. The 2 formulas would need to be slightly different but function the same.
If anyone can please explain how this should look, I would really appreciate it. Please let me know if I need to explain anything else.
Bookmarks