ExcelBanter - Hopefully my last question!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hopefully my last question! (https://www.excelbanter.com/excel-discussion-misc-queries/42580-hopefully-my-last-question.html)

r.p.mcmurphy

Hopefully my last question!

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:BJ4C4),C4,G4: BJ4)))*0.09615

Many thanks!

steve

JE McGimpsey

One way:

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

In article ,
"r.p.mcmurphy" wrote:

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:BJ4C4),C4,G4: B
J4)))*0.09615

Many thanks!

steve

All times are GMT +1. The time now is 11:08 PM.