ExcelBanter - Sum of numbers in multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum of numbers in multiple columns (https://www.excelbanter.com/excel-worksheet-functions/226573-sum-numbers-multiple-columns.html)

ALEX

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.

Mike H

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.

All times are GMT +1. The time now is 03:17 AM.