ResellerRatings Store Ratings - View Single Post

Epidemic · 10-02-2003, 04:04 PM

=IF(G14="Total",SUM(OFFSET(E7,-4,4):OFFSET(E7,6,4)),"")

Not sure if this does what you want but here give this a whirl.

ps this is a formula of course.

I did not generate a macro for this one.

10-02-2003, 04:04 PM	#7 (permalink)
Epidemic Registered User Join Date: Mar 2002 Posts: 400	=IF(G14="Total",SUM(OFFSET(E7,-4,4):OFFSET(E7,6,4)),"") Not sure if this does what you want but here give this a whirl. ps this is a formula of course. I did not generate a macro for this one. Last edited by Epidemic : 10-02-2003 at 04:17 PM.