I used to know how to do this but its slipped away from me....
On one sheet I have a number of cells which contain the code 'cc'.I want to get the sum of the values in the cells to the right of each one of the cells with cc in them.
The cells are all contained within a certain area but not in a table (there may be some tables within the area though). I dont see any reason why I couldn't make this area a named range.
I think when I was helped with this before it was to compile a list of the values in the adjacent cells, even though it wasn't possible to know how many there were and and now its just a sum of the numeric values so hopefully it should be a bit simpler.
I'd prefer a normal cell formula but VBA would be OK if its straightforward as i'm a bit rusty!
Any help would be greatly appreciated. TIA!
On one sheet I have a number of cells which contain the code 'cc'.I want to get the sum of the values in the cells to the right of each one of the cells with cc in them.
The cells are all contained within a certain area but not in a table (there may be some tables within the area though). I dont see any reason why I couldn't make this area a named range.
I think when I was helped with this before it was to compile a list of the values in the adjacent cells, even though it wasn't possible to know how many there were and and now its just a sum of the numeric values so hopefully it should be a bit simpler.
I'd prefer a normal cell formula but VBA would be OK if its straightforward as i'm a bit rusty!
Any help would be greatly appreciated. TIA!
