View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael at Thin Air
 
Posts: n/a
Default How can I add up lookups? Finding days in a week of a month

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