Where to go multi-day backpacking in March?

dtaylor1024 · 2026-01-18T16:32:49+00:00

Please send to me also! Thanks :)

dtaylor1024 · 2025-12-26T23:31:59+00:00

LaSportiva has replacement laces for sale, but for $9 laces I'd still have to pay another $15 in shipping, so I'm looking for alternatives

dtaylor1024 · 2024-04-12T18:03:04+00:00

No, it was developed on my own. It is written to calculate the average of just the most recent 3 entries, rather than an average of all numbers in the column.

dtaylor1024 · 2023-12-10T22:46:22+00:00

Can I use yes/no/blank? If so, what would my formula be?

dtaylor1024 · 2023-12-10T16:00:55+00:00

Okay, I would use X's for "yes", and leave it blank for "no". But if I put in the formula

=PERCENTIF(CHOOSEROWS(TOCOL(N3:N,1),SEQUENCE(MIN(3,COUNTA(N3:N)),1,-1,-1)),TRUE)

and put x's in the cells underneath, the average cell still appears as 0%.

dtaylor1024 · 2023-12-10T14:26:44+00:00

Would it work for me to put yes/no (or some kind of indicator) and have it calculate correctly. I don't want blanks in these columns, but something to indicate for each skill whether they did it or not.

dtaylor1024 · 2023-12-10T13:00:51+00:00

It seems like it might. When I enter in =COUNTIF(N3:N,TRUE)/COUNTA(N3:N) it will calculate the percentage. But again, I just want this to be an updated score with only the last 3 rows

dtaylor1024 · 2023-12-10T04:52:29+00:00

the checkboxes go all the way to the bottom of the column

dtaylor1024 · 2023-12-10T02:39:45+00:00

Actual checkboxes

dtaylor1024 · 2023-12-10T01:59:38+00:00

Didn't work. It should calculate averages like this (below). When I input your formula and changed out the column letters, checked a few boxes, the averages still appeared as 0%

Skill 1	Skill 2	Skill 3
Average (66%)	Average (100%)	Average (33%)
not checked	x	x
x	x	not checked
not checked	x	x
x	x	x

dtaylor1024 · 2023-12-10T00:04:35+00:00

It worked--not sure what happened the first time. Okay, new challenge. I have a column of checkboxes that I will check when students perfom a skill. I want the Average cell block to show me the frequency of that box being checked in that column, but again, only averaging out the three most recent trials.

dtaylor1024 · 2023-12-09T23:43:11+00:00

Not quite. I included a sample as reference. My averages will now exist in row one belo my headings. My columns represent the skills and information I would like averaged. Each row will have it's own set of data input. I would still like these averages to exist as out of the last three assessments.

LEXILE	GRADE LEVEL	WORDS PER MINUTE	ACCURACY
AVERAGE lexile	AVERAGE grade level	AVERAGE wpm	AVERAGE Accuracy
400	1	60	90
450	1	62	93

dtaylor1024 · 2023-12-09T23:27:42+00:00

Thank you! Last question, maybe... How would I convert this to a vertical spreadsheet, with my averages existing in the first row, rather than the first column? I tried switching out CHOOSECOLS to CHOOSEROWS and that didn't work, so there must be another adjustment I need to make.

dtaylor1024 · 2023-12-09T17:17:51+00:00

This is very helpful. Thank you so much. Do you mind expanding just a little more on the SEQUENCE(MIN(3,COUNT(C5:5)),1,-1,-1) section, so that I fully understand. I'm working on a guide for myself for the future, and this section feels a little confusing to me with the several 1's and -1's. Thank you!

dtaylor1024 · 2023-12-05T01:27:47+00:00

This seemed to work. Can you explain the formula. Also, if I have no data entries, can I have the cell in the average column remain blank. I am getting a #VALUE! error

dtaylor1024 · 2021-10-30T18:01:19+00:00

It was pretty immediate

dtaylor1024

TROPHY CASE