Oh boy! Call me Nuisance Mr FK.

  • Thread starter Thread starter sonar
  • Start date Start date
S

sonar

Hi,

I have looked at the formula and searched in Excel regarding the part
that makes up the formula you have given me, and even played aroun
with it.

=SUM(N(OFFSET($A$10,0,SMALL(IF((L10:BH10>0)*(MOD(COLUMN(L10:BH10)-12,8)=0),COLUMN(L10:BH10)),{1,2,3,4,5})-1,1,1)))

But, as things are, I am clueless.

If there is nothing that can be done to make it fail proof, e.g. i
less than 5 entries is made, then I must rather abort the idea, fo
good reasons.

Please can you help? I had no idea it would create errors should th
entries be less than 5. And I know you have been very helpfull so far
I appreciated that.

Humblest appologies.

Antoinette Pearce
Cape Town
South Afric
 
Hi
try
=SUM(N(OFFSET($A$10,0,SMALL(IF((L10:BH10>0)*(MOD(COLUMN(L10:BH10)-12,8)
=0),COLUMN(L10:BH10),COLUMN(IV10)),{1,2,3,4,5})-1,1,1)))
 
A Big thank you Mr Kabel,

its much appreciated.


:)

Hope other people will appreciate you just as much in future
 
Back
Top