Hopefully my last question!

R

r.p.mcmurphy

Newbie here! How do i get this formula to add the contents of BQ4 just
before the final *0.09615 calculation? its gotta be so simple i'm seeing
past it.

=SUM(IF(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0,IF((G4:BJ4<>"")*(G4:BJ4>C4),C4,G4:BJ4)))*0.09615

Many thanks!

steve
 
J

JE McGimpsey

One way:

=SUM(IF(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0,IF((G4:BJ4<>"")*(G4:BJ4>C4),
C4,G4:BJ4)),BQ4)*0.09615
 
Top