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.