Cardbox > Forums
> Macros and Programming > "Sum cell values to the right of "TOTAL""
How to automatically sum all cells next to a cell that has "TOTAL" as text.
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.
Winrock Corporation 200.87
Winrock Corporation 400.23
Acme Supplies 400
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.