Summing multiple criteria across rows and columns

[kimberly01]

I need to be able to solve the following problem without arrays or sum product solution. Would be grateful to anyone that can help.

If have a set of data with columns:
1 3 5 2 1 5 2 3

And rows:
Dog
Cat
Fish
Dog
Dog
Cat

and there is data in each cell in this matrix.

I need to sum the values where the column and row values match (i.e. sum all values where column = 1 and row = dog).

 

[Andrew Poulsom]

What do you mean by an array?