I have a table that has columns of days, 1-31 and another column with the day
of the week, Mon-Sun and then various columns of numbers for each day of the
month.
I want to be able to a get sum of all the numbers for each day of the week.
I am using lookup but this is only returning the last incidence and I need
all the numbers added together. Example, I need all widgets sold on Saturday
for the month.
TIA
Bookmarks