Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of cells in different rows & columns & criteria
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria across multiple columns and rows | Excel Worksheet Functions | |||
Count rows with criteria from two columns? | Excel Worksheet Functions | |||
Searching rows with multiple columns criteria | Excel Worksheet Functions | |||
Sum rows if two columns = specific criteria. | Excel Worksheet Functions | |||
Sum based on criteria in rows and columns | Excel Discussion (Misc queries) |