Adding an Amount from a Prior Week

Psilano

Hello,

I am currently trying to get a sum from two values. One of the values is from the most recent Sunday, and the other is the Sunday prior to the most recent one. I need to find the difference of them for a calculation I am using in another column. I am not sure of how to call upon the prior Sunday's value. I do have dates associated also. My idea was to have an If function that calls upon the column to check if it is sunday. Then to sum up the most recent week's value with the prior weeks, by using the Date column to do (Date@row-7) to get to the correct row. My issue now is how do I call upon the value column after that. Below is the formula I currently have. Any help will be greatly appreciated.

=if([Choose the Day]@row = "Sunday", sum([Body Fat Percentage]@row,(Date@row-7 ?????

Kind Regards,

Pete

Paul Newcome

Are you able to provide some screenshots for reference?

Psilano

SS Community.JPG

Hi Paul, please see attached. You can see that there is a difference between the body fat percentages. I need the formula in the "Body Fat % Change" column to be able to refer to previous weeks body fat and find the difference between that number and the current week. I am just unsure how to call upon the previous week's every time.

Paul Newcome

Are you going to also need to include certain criteria such as the name for unique identification, or are you just looking for the last entry, or are you looking for the last "Sunday" entry? Is it a combination of some/all of those? Is it something different, and I am just completely missing the target here?

Psilano

Hi Paul, I am sorry for not being more clear. I do need the Body Fat Percentage along with the name from the prior week. As the name will help associate who's body fat percentage is whoever's. I truly appreciate the help here. I am guessing I need to use some sort of SUMIFS formula now.