Re: over my head
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
need to pick up every 7th cell
=I105+I111+I118+I125+I132+I139+I146+I153
The interval isn't consistent. It starts at 6 and then goes to 7.
So, based on that try this:
=I105+SUMPRODUCT(--(MOD(ROW(I111:I170)-ROW(I111),7)=0),I111:I170)
Adjust the end of the range as needed.
--
Biff
Microsoft Excel MVP
"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D011947E-9728-4EAA-BDFA-075024080B74@xxxxxxxxxxxxxxxx
is it possible to combine these two formulas? i have a list of names going
across a row then i need to pick up every 7th cell going down the column
for
each name and sum that value. is this even possible to do without having
to
scroll and +? im going crazy!!
=INDEX($I$154:$CU$154,ROWS(154:$154)*6-5)
=I105+I111+I118+I125+I132+I139+I146+I153
.
Relevant Pages
- Re: CScrollView: How to Tell If Scroll Bar Visbile
... Make your window that large. ... Adjust the parent frame ... Note it is your responsibility to set the scroll range, so once you have resized the ...
(microsoft.public.vc.mfc) - Re: CScrollView: How to Tell If Scroll Bar Visbile
... adjust the frame area to be big enough to display the whole image, ... Adjust the parent frame ... Note it is your responsibility to set the scroll range, so once you have resized the ...
(microsoft.public.vc.mfc) - Re: Strange times
... >> There's a difference between configure and adjust. ... try moving your mouse over the time applet and scroll the scroll buttun ... I have my HR9 Time Applet set to synchronize with Red Hat. ... > In love I believe and in Linux I trust! ...
(Fedora) - Re: scrolllist gadget question
... Is there an easy way to prevent the scrolllist gadget to respond on ... and redo the Adjust change. ... If you are using the scroll list gadget then you will probably find the ... I assume that your scroll list does not have flags bit 0 set ('allow ...
(comp.sys.acorn.programmer) - Re: Notepad functionality due to the OS W2K
... I do to, but in trading, sometimes I need t o adjust the speed up and down. ... How are you navigating in Notepad? ... I mouse around, I favor using the scroll wheel to crawl down a document, at ...
(microsoft.public.win2000.general) |
|
