Sum of numbers in multiple columns

[Alex]

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

 

[Mike H]

Hi,

Try this

=SUMPRODUCT((A2:A9="abc")*(B1:G1="Tuesday")*(B2:G9))

Mike