Hello, on my excel, the SUMIFS function does not work despite the fact that I used the same as you. Everything has been done identically since the beginning on the entire excel. Can you help me please?
Hey everyone, for anyone struggling with Sumifs formula, instead of typing TBLData just click and drag through the column you are trying to highlight in your table and then just follow the equation that way. Hope this helps anyone (sorry for the bad description haha)
Hi John This tool is supercool, I learned a lot by watching your videos! On the other hand I made the Rolling Days the same way as you did but after I made the SUMIFS formula, my rollingdays bar for every athlete stayed 0. Why did it happen, and what are the solution to fix it? Kind regards
Does the formula exist in your excel version? type = SUMIFS and see if you get anything. It is quite a big formula so it can be easy to make a mistake.
Hi John, Rolling Load formula is not reading. The issue is with rolling days. In my data base I have only entered two days of data for my template. Will this affect the formula as you have used it? I have tried changing the rolling days to two, this still did not read.
Those are great tutorials! Thanks for that! I have one question that I cannot seem to be able to figure out myself. I am trying to "convert" that for individual sports for athletes that have multiple sessions per day. For example, an athlete might have 3 different sessions so it will occupy 3 slots in the database sheet with the same date, but different rpe, duration, and sRPE numbers. I am trying to figure out how I could add the sRPE (for the whole day, the sum of the 3 sessions in the above case), and sleep quality and quantity. Because I have 3 different slots with the same date and I want to put only 1 value per date for sRPE and sleep it does not seem to work properly! Thank you in advance!
Make sure you only enter sleep values once per day, leave other rows blank. Average RPE for a day, total load, total duration etc should calculate OK in the pivot tables but you might need to change the formula that I originally created.
Because the moving average has multiple criteria: it must be for just that athlete, between two dates (there may be multiple sessions on a day and there will be many athletes in the data sheet). I would love to know if your suggested option can do this (i haven't used the analysis tool pak much to be honest).
Thank you for this. I have to re-learn this every season
RollingDays field does not show in the FieldList. What did I miss here?
Hello, on my excel, the SUMIFS function does not work despite the fact that I used the same as you. Everything has been done identically since the beginning on the entire excel.
Can you help me please?
what is the duration?
Hey everyone, for anyone struggling with Sumifs formula, instead of typing TBLData just click and drag through the column you are trying to highlight in your table and then just follow the equation that way. Hope this helps anyone (sorry for the bad description haha)
Hi John
This tool is supercool, I learned a lot by watching your videos! On the other hand I made the Rolling Days the same way as you did but after I made the SUMIFS formula, my rollingdays bar for every athlete stayed 0. Why did it happen, and what are the solution to fix it?
Kind regards
Hi,
Any idea why the rolling formula isnt working at my excel sheet? Is it because Im working with a European version of excel?
Hey John, can't seem to get the =sumsif formula to work on Mac Excel, any solutions?
Does the formula exist in your excel version? type = SUMIFS and see if you get anything. It is quite a big formula so it can be easy to make a mistake.
Hi John,
Rolling Load formula is not reading. The issue is with rolling days. In my data base I have only entered two days of data for my template. Will this affect the formula as you have used it? I have tried changing the rolling days to two, this still did not read.
Those are great tutorials! Thanks for that! I have one question that I cannot seem to be able to figure out myself. I am trying to "convert" that for individual sports for athletes that have multiple sessions per day. For example, an athlete might have 3 different sessions so it will occupy 3 slots in the database sheet with the same date, but different rpe, duration, and sRPE numbers. I am trying to figure out how I could add the sRPE (for the whole day, the sum of the 3 sessions in the above case), and sleep quality and quantity. Because I have 3 different slots with the same date and I want to put only 1 value per date for sRPE and sleep it does not seem to work properly! Thank you in advance!
Make sure you only enter sleep values once per day, leave other rows blank. Average RPE for a day, total load, total duration etc should calculate OK in the pivot tables but you might need to change the formula that I originally created.
@@JohnLythe perfect, thank you very much for your answer and the great tutorials in general!
Muito obrigado.
What paste option do you use???
Generally, Paste Special Values is the option i use
Why didn't you just use Data Analysis in Data tab to create rolling average?
Because the moving average has multiple criteria: it must be for just that athlete, between two dates (there may be multiple sessions on a day and there will be many athletes in the data sheet). I would love to know if your suggested option can do this (i haven't used the analysis tool pak much to be honest).
Rolling days did not work for me