Perhaps one of these:

This one sums alternating items in the range,
beginning with the 1st referenced value:
=SUMPRODUCT(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))* (MOD(COLUMN(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))) ,2)=MOD(COLUMN(OFFSET(F11,0,(D3))),2)))

This one sums range items that are in ODD numbered columns:
=SUMPRODUCT(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))* (MOD(COLUMN(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))) ,2))=1)

This one sums range items that are in EVEN numbered columns:
=SUMPRODUCT(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))* (MOD(COLUMN(OFFSET(F11,0,(D3)):OFFSET(F11,0,(D4))) ,2))=0)

NOTE: Since text wrap will impact the display, there are NO spaces in those
formulas.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)







"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:7af3f35f4a300@uwe...
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