I would be grateful to receive a steer as to the formula to use, where I have a list, that involves 20 names, in 5 different areas identified by an abbreviated label, and those names fall into either T or C types which alter frequently although the area and name does not. I need to produce a total for each T or C according to area. without altering the position of the original data.
I have set out a small array showing name, type and class although in practise the name is irrelevant to the totals needed
<tbody>
</tbody>
I have set out a small array showing name, type and class although in practise the name is irrelevant to the totals needed
<tbody> </tbody> Easy to do in old fashioned Basic. I have tried match and index but my lack of expertise with Excel a frustrating handicap. Many thanks for reading this and if you can help that would be appreciated |
<tbody>
</tbody>