UserInDistress21
New Member
- Joined
- Sep 1, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am trying to calculate something in the likes of =AVERAGE(B3:B11, B13:B19) that would automatically expand when I add new data to my dataset (and refresh the pivot table). I have been bashing my head around this for quite some time now but I can't seem to find an answer.
My original dataset has two columns of interest: "Date" and "Time Spent", with sometimes several items for one day. This pivot table sums all the hours spent during a certain week. What I would like is to calculate the average and the standard deviation of the Time Spent/Week using the pivot table.
Can someone help me with this?
My original dataset has two columns of interest: "Date" and "Time Spent", with sometimes several items for one day. This pivot table sums all the hours spent during a certain week. What I would like is to calculate the average and the standard deviation of the Time Spent/Week using the pivot table.
Can someone help me with this?