| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why is this not working?
why is this not working? it should add up the values of every 6th cell (H6
through to FB6), but if any cell is over the value of D6 then D6 's value is taken as the value for that particular cell in that particular instance. it seemed to be working, but if i enter a value of over D6 in H6 etc, the answer is worng. =SUMPRODUCT((MOD(COLUMN(H6:FB6),6)=2)*(H6:FB6<=D6) *H6:FB6)+D6*SUMPRODUCT((MOD(COLUMN(H6:FB6),6)=2)*( H6:FB6D6)) cheers! steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
| Working time and days | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
| Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
Threaded Mode
