ST Alpha - "Excel help question" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 170

Excel help question

Posted by Gwaahjo Oct 15 '08, 10:52

So i have 1 box... in that box i want to have the sum of 100 other boxes. These other boxes are all in the same column... but they are rows 3, 8, 13, 18, 23... etc..

Is there a way to make it select those without clicking 100 times?

Responses:

=SUMPRODUCT(--(MOD(ROW(C17:C31),5)=3),C17:C31 ) - oblique, new and shiny Oct 15, 11:03 3
- *swoon* -- nm - ReluctantCynic Oct 15, 11:19
- That is a cool solution. -- nm - psilotum Oct 15, 11:10
- This link should help make sense of the forumla -- (link) - oblique, new and shiny Oct 15, 11:07
It'd probably take longer to figure out how to do it without clicking 100 boxes then it would take to just click the 100 boxes. ;) -- nm - Cuzzin Todd Oct 15, 10:55 4
- I was just curious since I've done it and have to do it many more times! -- nm - Gwaahjo Oct 15, 10:56 3
  - I do know from experience if you cut-n-paste that formula into other cells it changes the cells it sums up. - Cuzzin Todd Oct 15, 10:58 2
    - yes, this is something i want to do... but which formula do i want to cut and paste? - Gwaahjo Oct 15, 10:59 1
      - Changes the sme way if you move from column to column too. - Cuzzin Todd Oct 15, 11:07
=sum(b3,b8,b13,b18,...) -- nm - psilotum Oct 15, 10:54 1
- right, i just didn't know if there was a way to do it without clicking/typing in every number - Gwaahjo Oct 15, 10:55
Step 1: cut a hole in the box....Step 2: put your query in the box...Step 3: make her open the box. - musubi Oct 15, 10:54 2
- yeah, but then i have to do another 100, with every five boxes in the same column... etc etc 3 more times - Gwaahjo Oct 15, 10:58 1
  - If they are all in the same column, you can just use the fill tool to repeat the process. But the first one, you have to click 100 times, I think. - musubi Oct 15, 11:04

Post a message top

Excel help question

Replies are disabled on threads older than 7 days.