Hi all,
Any idea what formula I would need for this?
Column a has a load of names. Often the names are repeated. Next to the names in column B is the amount of money they spend a day. What formula would I put to addthe total amount that individual spends. I know it must be a Sum and Vlookup but can't get it to work.
Thanks guys.
Any idea what formula I would need for this?
Column a has a load of names. Often the names are repeated. Next to the names in column B is the amount of money they spend a day. What formula would I put to addthe total amount that individual spends. I know it must be a Sum and Vlookup but can't get it to work.
Thanks guys.