|
Posted to microsoft.public.excel.programming
|
|
|
Need to adjust formula accordingly
Change the eight to a nine.
sonar < wrote:
Hi, I had the formula:
=SUM(N(OFFSET($A$9,0,SMALL(IF((L9:BH90)*(MOD(COLU MN(L9:BH9)-12,8)=0),COLUMN(L9:BH9),COLUMN(IV9)),{1,2,3,4,5})-1,1,1)))
I had to ad in extra columns for my nightshift
I tried to adjust the formula as follows:
=SUM(N(OFFSET($A$14,0,SMALL(IF((K14:BM140)*(MOD(C OLUMN(K14:BM14)-12,8)=0),COLUMN(K14:BM14),COLUMN(IV14)),{1,2,3,4,5 })-1,1,1)))
but the outcome is not the same,
what do I have to do to do any adjustments in future, should I wish to
ad more columns in between.
My cells a
K14, T14, AC14, AL14, AU14, BD14, BM14 (Every 9th cell)
help will be most appreciated.
---
Message posted from http://www.ExcelForum.com/
|