jackdiamond
Board Regular
- Joined
- Oct 10, 2007
- Messages
- 220
Hi,
Is there anyone out there that could help me with a formula for the following please?
I need to find an average for "Richard Harris" of entries made over 3 batches of product in 4 different areas.
eg
CELL A............CELL B..........CELL C.........CELL D..........CELL E
BATCH 1
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
BATCH 2
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
BATCH 3
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
I hope someone can help!
Also, how can I copy and paste what I have on my excel screen so it looks like how it should when I paste it here?
Thanks
Stu
Is there anyone out there that could help me with a formula for the following please?
I need to find an average for "Richard Harris" of entries made over 3 batches of product in 4 different areas.
eg
CELL A............CELL B..........CELL C.........CELL D..........CELL E
BATCH 1
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
BATCH 2
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
BATCH 3
Name.............area 1...........area 2..........area 3..........area 4
John Terry........10................20...............30...............10
Richard Harris....12................10...............60...............12
I hope someone can help!
Also, how can I copy and paste what I have on my excel screen so it looks like how it should when I paste it here?
Thanks
Stu