ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sum program (https://www.excelbanter.com/excel-programming/363398-sum-program.html)

enyaw

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.

Bob Phillips

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.





All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com