for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

GlennR Sep 2018 9:30pm, 30 Sep 2018 38,249 posts	Quote Pin GlennR Not sure what you mean. Excel doesn’t really produce lists. Obviously you can make a list of Saturdays then flag the third one in a given month, using COUNTIF().
ChrisHB Sep 2018 9:46pm, 30 Sep 2018 17,228 posts	Quote Pin ChrisHB Thanks, I think just asking the question has led me to an answer - if the date is between 1 & 7 then it's the first Saturday, etc. That's good enough.
Red Squirrel Oct 2018 1:28pm, 5 Oct 2018 20,859 posts	Quote Pin Red Squirrel Hi folks. I can't get a correct running total going in column D, asking for the info to come from column B. I know this is the simplest thing but it eludes me. I've done: =SUM($B6+$B7) with no spaces to draw total into column D. When I drag this down, all that happens is that the last cell is added to the new cell which looks correct but the totals aren't correct.
Diogenes Oct 2018 1:43pm, 5 Oct 2018 30,569 posts	Quote Pin Diogenes In D6 i'd enter =B6 Then in D7 =(D6+B7) Then copy that down to the remaining rows in column D More elegant solutions may be available
um Oct 2018 2:25pm, 5 Oct 2018 535 posts	Quote Pin um Try setting D6 as =sum(B$6:B6), then dragging down. You should then get each cell Dnn as =Sum(B$6:Bnn)
GregP Oct 2018 4:29pm, 5 Oct 2018 107,436 posts	Quote Pin GregP Theoden
Diogenes Oct 2018 6:09pm, 5 Oct 2018 30,574 posts	Quote Pin Diogenes Que?
GregP Oct 2018 6:20pm, 5 Oct 2018 107,444 posts	Quote Pin GregP Wrong thread. Mea culpa.
Red Squirrel Oct 2018 12:14pm, 10 Oct 2018 20,861 posts	Quote Pin Red Squirrel um - thank you
GregP Oct 2018 3:01pm, 10 Oct 2018 107,483 posts	Quote Pin GregP aF1D5B44