sum of cells in different rows & columns & criteria

Q

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top