On 2002-11-06 18:08, brettvba wrote:
Ive got a formula with a range
eg =sum(a2:a5)
what im wanting to do is have the end row value in a cell eg C5 with a value of 6.
and reference that in the formula eg
=sum(a2:a&C5)
but that doesn't seem to work any Ideas?
Brett
On 2002-11-06 18:22, brettvba wrote:
[...]the formula im trying to get this to work on
=SUMIF(Christchurch!$B:$B,$A3,Christchurch!$E:$E)+SUMPRODUCT((Christchurch!$B$2:$B$18880=$A3)+0,(Christchurch!$F$2:$F$18880/Christchurch!$G$2:$G$18880))
where im trying to replace the 18880 with a cell value?[...]
On 2002-11-06 18:22, brettvba wrote:
ok thanks Mark I will give you the formula im trying to get this to work on
=SUMIF(Christchurch!$B:$B,$A3,Christchurch!$E:$E)+SUMPRODUCT((Christchurch!$B$2:$B$18880=$A3)+0,(Christchurch!$F$2:$F$18880/Christchurch!$G$2:$G$18880))
where im trying to replace the 18880 with a cell value?
Brett