| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
