View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Legal-Time-Guy Legal-Time-Guy is offline
external usenet poster
 
Posts: 1
Default Formula: values in one column based on corresponding data

My goal is simply this - I want to add a series of values (hours and minutes)
worked on specific projects within one months time. Now, the month/day/year
is listed in a separate column. Thus, one column lists all the hours and
minutes used to complete a project and now I want to add up those values for
a specific month's time. The reason is so I can explain how much time was
spent doing a specific task for various cases. I believe the formula starts
with "=sumif(" but after that I simply do not know.