I'm going to try and explain my request, some how!!
In column A the user will enter text like BT1, BT2, BT3
In column C a value is generated automatically
I need to have cells that sum the values in the C column based on the values of the A column,
In other words I need the summed value of C for all the entries. (Ohh this is difficult.)
If column A has 4 "BT1" I need it to sum the four values in column C that pertain to "BT1"
Excel.JPG
Bookmarks