#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default sum program

I have a userform that allows to input information into a worksheet. When a
certain number of items are entered i want to be able to sum three of the
columns. I need to be able to input more information after each sum but i
need to just sum each group of information.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default sum program

You could add a formula into a cell like this

Range("A1").Formula = "=SUM(C:E)"

other than that, you are a bit short on detail.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"enyaw" wrote in message
...
I have a userform that allows to input information into a worksheet. When

a
certain number of items are entered i want to be able to sum three of the
columns. I need to be able to input more information after each sum but i
need to just sum each group of information.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
Program juanpablo Excel Discussion (Misc queries) 0 July 2nd 08 02:12 AM
IF () program Bee Excel Discussion (Misc queries) 1 June 5th 06 03:15 PM
Program to add a row? Don Excel Programming 1 January 27th 05 01:37 PM
merging excel program with tdc finance program judy Excel Programming 0 November 5th 03 08:01 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"