HiI have two columns A, BA has Employee NamesB has expenditure through the monthI would like to total the cells for expenditure where employee name is 'John'I assumed it would be something like=SUM(VLOOKUP("JOHN",A1:B100,2))but that only returns the last expense.Help!
Wait for VoG™bump ^^^^^
Sorry let me explain a bit futher.....| A | B | Mick 500 John 240 Andy 200 John 100 Mick 50Total needed of all 'John' figuresI can do this manually, but sometimes there are several hundred entries (It's not me that designs the original spreadsheet - I just get to sort it out !)
something like, highlight all of johns figures and press the "autosum" button, looks like a weiird "E"??just a suggestion.
In column C type:=IF(A1='John', B1, "")(assuming your list starts in row 1)Populate column C with this formula to the bottom of your list - the row number will automatically update for each row you go down. Then just sum up the results.
Many ThanksSimple answer as always and worked perfectly.Regards
If you name your columns i.e Names and Amount, then in C1 insert the name you are looking ofr and name this cell Name, then you can insert in C2 the formula =SUMIF(Names,Name,Amount)to generate a more general purpose form of the same thing.
This thread is now locked and can not be replied to.
Dell XPS 13 9370 (2018) review
Best Keyboards for Designers & Artists
What to ask Siri on the HomePod
Meilleurs VPN (2018)
© Copyright 2018 IDG UK. All Rights Reserved.