You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a table in numbers that shows each date I swam.
I want to have a column that shows how many yards I swam in the previous 10 days.
I don't want to have every single day on the spreadsheet even though the task would be a lot easier.
I would also prefer not to show the total yards swam each day because this number will always be 1500.
Can I do this in the format shown below?
thank you.
MacBook Pro 13″, macOS 14.5
From you description I think you are looking for something like this:
In F2, filled down:
=COUNTIFS(A,"<="&A2,A,">="&A2−10)×1500
This looks at the date column, counts how many entries occurred during the 10 days including the current day, and multiplies by 1500.
Depending on how you want to count you may want to adjust the >= to >.
SG
A formula to show which period of time I swam the most
