One way is via SUMIF
In G1:I1 are the identifiers: R, S, V
In G3: =SUMIF($B:$B,G1,$A:$A)+SUMIF($D:$D,G1,$C:$C)
Copy G3 across to I3
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Question, Mark" wrote:
What formula is needed in G3, H3 & I3 to create the combined totals of row 2
& 3?
Columns B, D & F identify the numbers in A, C & E.
Finished spreadsheet will have 7 number colums with corresponding identifer
colums & 5 different identifers to total. Excel 2003.
Thanks for any help.

a b c d e f g h i
1 Totals: R S V
2 1 R 1 S 1 V
3 1 V .5 R .5 S 1.5 1.5 2