Hello, I have a spreadsheet with the following formula modified for 50
different code numbers (ranging from 10 to 636)

=SUMPRODUCT((F9:AW28=10)*B9:AS28)
=SUMPRODUCT((F9:AW28=636)*B9:AS28)


Now I need to add 4 subcategories to these codes and be able to total them,
but still retain the original totals.

So my codes would become 10FA or 10C or 636D etc
Can I pick this info out of the sheet without messing up the original counts?

Any help would be greatly appreciated

Thank you