Lookup to sum totals

kac1125

New Member
Joined
Jul 31, 2014
Messages
42
Hello,

Looking for a sum/vlookup formula to sum up the total values for a certain criteria. For example I am looking to sum up Days for a name I input in cell D2 so lets say D2 is Joe, I want E2 to read 9.5. Any help will be appreciates. THanks in advance!
NameqtyDays
Joe507.5
John402
Rich301
John202
John153
Rich101
Dan402
Tom402
Joe302
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

NARAYANAN

New Member
Joined
May 12, 2017
Messages
2
USE SUMIFS FORMULA

ENTER =+SUMIFS(C2:C10,A2:A10,D2) IN E2 AND INPUT JOE IN D2 TO GET YOUR RESULT
 

kac1125

New Member
Joined
Jul 31, 2014
Messages
42
USE SUMIFS FORMULA

ENTER =+SUMIFS(C2:C10,A2:A10,D2) IN E2 AND INPUT JOE IN D2 TO GET YOUR RESULT
Thanks! this worked! one more question. what if I am using a slicer? It seems to pull the full sum instead of the filtered values. Please let me know if you have any ideas.

Thanks again!
 

Watch MrExcel Video

Forum statistics

Threads
1,095,728
Messages
5,446,172
Members
405,388
Latest member
Arlind

This Week's Hot Topics

Top