I have a sheet with days of week in one column and values in adjacent cells;
I need to work out the total for each day of the week - see below for example:
Monday 1000
Tuesday 2000
Wednesday 3000
Monday 500
Tuesday 2000
Wednesday 5000

Totals would be 1500, 4000 & 8000 but what is the formula to do this?
--
DJ