Home

Macros and Programming

 

CardboxForumsMacros and Programming > "Sum cell values to the right of "TOTAL""

Sum cell values to the right of "TOTAL"

How to automatically sum all cells next to a cell that has "TOTAL" as text.

Current user: [none]
Register / Log In · Help

Posted By Post

gabe17

18-Jun-2009 14:54

Hello,

I am completely new to Macros, so sorry if this is completely obvious.

I have a form that has many totals from different types of materials.

Example:

Drywall
Winrock Corporation 200.87
Winrock Corporation 400.23

..............TOTAL 601.10

Cleanup
Acme Supplies 400
Rona 200
........TOTAL 600

......SUBTOTAL

In the cell right of the subtotal cell I want a macro that will sum all cells in the worksheet that have a cell to the left that has "TOTAL" as text.

The TOTAL and the cell with the value next to it will always be in the same column, however, the rows will always be different.

Thanks for any help anyone can provide.

Much appreciated!

Gabe

Quick Reply

Please log in or register before trying to post a reply.

 
© 2010 Cardbox Software Limited   Home