View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WH99 WH99 is offline
external usenet poster
 
Posts: 51
Default Sumproduct by date

I have a data sheet that get entered with date and hours for the year.
Some days we might have several entries or just one, it depends on how much
work is done.
I have a table numbered 1 to 31(col A). They corespond to the days in a
month. What I need is a formula down col B (1 to 31 days) to sum the total
for each day for the selected month.
--
WH99