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,
Bookmarks