| Home |
| Search |
| Today's Posts |
|
#18
|
|||
|
|||
Getting error message NAME?
steve "RagDyer" wrote in message ... Would you perhaps be interested in a *non-array* formula? Try this: =(SUMPRODUCT((MOD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4<=C4 )*G4:BJ4)+C4*SUMPRODUCT((M OD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4C4))+BQ4)*0.09615 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "r.p.mcmurphy" wrote in message ... That's it! Brilliant! however there seems to be a problem with the original part now. where i wanted each 5th cell to be read, if the value of that cell was higher than cell C4 then C4's value would take precedent. thanks for your help! steve "Domenic" wrote in message ... In article , "r.p.mcmurphy" wrote: Excel is not accepting it for some reason. any idea where the fault may be? If you're copying and pasting the formula into your worksheet, make sure that a line break hasn't been added. im a bit confused about the bit you added in order to add the value of BQ4...this bit.. +IF((BQ4<"")*(BQ4C4),C4,BQ4)) why does it refer to C4? I assumed, incorrectly it appears, that BQ4 would following the same logic as cells in G4:BJ4. Maybe this what you mean... =(SUM(IF((G4:BJ4<"")*(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0),IF(G4:BJ4C4,C 4,G4:BJ4)))+BQ4)*0.09615 Is it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
