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 t
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