The easiest way of doing it is "Defined Names ranges" in both vertical and
horizontal data range

Formula: = Debbie Guy


"Pebbles" wrote:

I have a huge spreadsheet (sample below) and I need to know the value of what
2 people have sold. The problem is that the men are listed along the columns
and the females are in the rows. I'm sure it's simple - I'm just mental
blocking.
The sort of results I'd expect a Debbie and Guy have sold $12,100/George
and Rebecca have sold $3,000.
A B C D E
1 Bob John Guy George
2 Jane $100 $600 $23,000 $2,000
3 Rebecca $200 $5,000 $43,000 $3,000
4 Alison $300 $8,000 $53,000 $400
5 Clair $400 $2,000 $70,000 $5,450
6 Debbie $800 $1,000 $12,100 $8,000

Thanks
--
Pebbles