Hi

I am using this formula to sum colums in row f, between the range D3 to D4

sum(offset(F11,0,(D3)):offset(F11,0,(D4)))

All working worked well, then I had to insert another columns every other one,
along page and therefore my required data is in alternative cells starting
from the value in D3 and ending in the value in D4

How do i adjust, revamp, the formula to count the original values.

I have tried to look on the treads for sumproduct, but unable to manipulate
for my end result

Help would be appriciated

regards

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1