| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of numbers in multiple columns
Say I have a table like this:-
---------------------------------------------- Name Monday Tuesday Wednesday Monday Tuesday Wednesday ABC 20 10 5 7 8 7 DEF 1 4 7 6 13 14 ---------------------- Now at the end column, I would like to sum all the numbers under columns Tuesday for ABC, DEF, etc. individually. Help please. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of numbers in multiple columns
Hi,
Try this =SUMPRODUCT((A2:A9="abc")*(B1:G1="Tuesday")*(B2:G9 )) Mike "Alex" wrote: Say I have a table like this:- ---------------------------------------------- Name Monday Tuesday Wednesday Monday Tuesday Wednesday ABC 20 10 5 7 8 7 DEF 1 4 7 6 13 14 ---------------------- Now at the end column, I would like to sum all the numbers under columns Tuesday for ABC, DEF, etc. individually. Help please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| move list of numbers from one column to multiple columns | Excel Discussion (Misc queries) | |||
| Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
Linear Mode
