UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC

[CAPTGNVR]

DEAR PROGRAMMERS
PLS HELP ME IN THE FOLLOWING:

USING LIST BOX, I MARK THREE SETS OF GROUPS FOR THEIR REWARD SUMS. SO I USE
THE MULTISELECT AND THEN USE VB TO TRANSFER THEIR NAMES. SO FAR SO GOOD.

CHARLIE 100
ROMEO 200
TOM 100
1STGROUP


ALFA 500
BETA 500
GAMA 500
TOP GROUP


LIKE THIS I WILL HAVE MANY GROUPS. ABLE TO GET THE GROUPS ISOLATED BY USING
LISTBOX AND VB.
I AM UNABLE TO WRITE THE SUM FORMULA IN VBTO AUTOMATICALLY CALCULATE THE
TOTAL SUM OF THE BONUS AWARDED FOR THE FIRST GROUP AND TOP GROUP AND SO ON.

PLS HELP

WHAT I AM UNABLE TO DO IS AT THE END OF EACH GROUP I AM UNABLE TO ENTER THE
SUM FUNCTION AS THE NOTATION IS DIFFICULAT AND NO IDEA HOW TO MAKE THE
STATEMENT IN VB USING OFFSET OR HOW TO MAKE OUT IN VB HOW MANY CELLS TO THE
TOP IT MUST ADD. LIKE SUM( D20.D10).

THANKING YOU
CAPT VENKAT RAJARAM

 

[Bob Phillips]

See response in excel.misc.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Don Guillett]

And, PLEASE, do not type in all caps. It is considered to be very rude.