I have a set of data that looks like the attached table. I want to be able to sum all the values that fall under the Alphas, Betas, X-Rays etc. for a particular specimen. I suppose the SUMIF function with INDEX and MATCH should work, however i am unable to put the formula together. Any help would be much appreciated.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
Alpha | Beta | X-Ray | Gamma | Neutron | |||||||||||||||||||||||||
Alpha | Beta | Gamma | Neutron | Alpha | Beta | X-Ray | Beta | X-Ray | Gamma | Neutron | Beta | X-Ray | Alpha | Beta | X-Ray | Gamma | Neutron | Beta | X-Ray | Alpha | Neutron | Gamma | |||||||
Spec A | 17 | 44 | 28 | 38 | 28 | 1 | 2 | 4 | 3 | 6 | 12 | 10 | 8 | 3 | 12 | 8 | 9 | 2 | 6 | 8 | 5 | 10 | 7 | 5 | 8 | 4 | 10 | 12 | |
Neutron | X-Ray | Gamma | Neutron | Alpha | Beta | Gamma | Alpha | X-Ray | Gamma | Neutron | Beta | X-Ray | Alpha | Beta | X-Ray | Gamma | Beta | Gamma | X-Ray | Beta | Alpha | Neutron | |||||||
Spec B | 26 | 41 | 32 | 29 | 27 | 8 | 9 | 12 | 7 | 10 | 4 | 6 | 7 | 10 | 7 | 6 | 8 | 8 | 1 | 12 | 5 | 4 | 8 | 10 | 3 | 9 | 8 | 6 | |
Neutron | X-Ray | Gamma | Neutron | Alpha | Beta | Gamma | Alpha | X-Ray | Gamma | Neutron | Beta | X-Ray | Alpha | Beta | X-Ray | Gamma | Beta | Neutron | X-Ray | Alpha | Gamma | Beta | |||||||
Spec C | 33 | 36 | 34 | 26 | 23 | 4 | 4 | 8 | 7 | 8 | 10 | 9 | 12 | 6 | 1 | 5 | 2 | 12 | 8 | 6 | 12 | 8 | 10 | 7 | 4 | 5 | 12 | 8 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>