sum of cells in different rows & columns & criteria

[Question, Mark]

Hi,
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

 

[Max]

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

 

[Max]

Errata, missed cols E n F earlier. Line:

In G3: =SUMIF($B:$B,G1,$A:$A)+SUMIF($D:$D,G1,$C:$C)

should read:

In G3:
=SUMIF($B:$B,G1,$A:$A)+SUMIF($D:$D,G1,$C:$C)+SUMIF($F:$F,G1,$E:$E)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

 

[T. Valko]

Try this:

=SUMIF($B2:$F3,G1,$A2:$E3)

Copy across

 

[Question, Mark]

thanks, your answer worked great.

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]

Thanks, I was able to put both replys to use.

Try this:

=SUMIF($B2:$F3,G1,$A2:$E3)

Copy across

 

[T. Valko]

You're welcome. Thanks for the feedback!