Sum from multiple columns based on multiple criteria

I'm trying to sum multiple columns together based on criteria. The first criteria is the names have to match and the second criteria times have to match. I cant use a helper column because this data will change regularly both the numbers and the names will change.
I've tried index and match and sumproduct and I can't get either of them to work with this, Although I'm not really familiar with sumproduct so I may just not know how to do it but the last formula I tried was =SUM(IF(AND($E$29=E27,$A$30=$A$2:$A$25),B2:T26)) and it does not work at all. any help you could give would be great!

Thanks,

You have a single space after the names Andrew, Alex and Zach in cells C27:E29, so you need to remove those.

Then you can use this formula in cell B30:

=SUMPRODUCT((B$29=$B$27:$T$27)*($A30=$A$2:$A$25),$B$2:$T$25)

and you can copy this across and down as required.

Hope this helps.

Pete

Thanks for the reply Pete_UK and FlameRetired and sorry for my late response! both of your formulas work great for what I asked for! I'm wanting to summarize the numbers under one name if there are multiple names listed. I will attach an updated file for the way I would like the data to ultimately look like..

Try


in B30

=SUMPRODUCT(($B$2:$T$25)*($A$2:$A$25=$A30)*($B$27:$T$27=B$29))

Copy across and down

JohnTopley, Your formula worked great thanks for the help!