yes it should.
but its not working. let me give you the full formula as im using it.
=(SUMPRODUCT((MOD(COLUMN(H6:FB6),6)=1)*(H6:FB6<=D6 )*H6:FB6)+D6*SUMPRODUCT((MOD(COLUMN(H6:FB6),6)=1)* (H6:FB6D6)+FK6))*(D6*$E6)/(D6*52)
its as before, only with adding FJ6 what ever its value and then multipling
the whole answer by (D6*E6)/(D6*52)
any help?
steve
"Domenic" wrote in message
...
The formula seems to work as you've described. Let's take a look at the
following example where...
D6 contains 100
H6 contains 180
N6 contains 60
T6 contains 160
Z6 contains 80
...shouldn't the answer be 340?
In article ,
"R.P.McMurphy" wrote:
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
|