T
tpayne
I have a spreadsheet I have built to keep track of jobs and the amount of
time worked on each. I have about 5 rows of data showing dates and time in
minutes worked on for each job number. My question is I am trying to create a
formula that will check a range of data for a date and then add up the amount
of minutes in the cell below it. For example, I would have today’s date
7/23/07 then in the cell directly below it I will have the value 28 for 28
minutes. I did a =countif( ) function to find how many instances of the date
were shown in the range however I can’t figure out how to add the minutes
that are below each instance in the same function. Can this be done?
time worked on each. I have about 5 rows of data showing dates and time in
minutes worked on for each job number. My question is I am trying to create a
formula that will check a range of data for a date and then add up the amount
of minutes in the cell below it. For example, I would have today’s date
7/23/07 then in the cell directly below it I will have the value 28 for 28
minutes. I did a =countif( ) function to find how many instances of the date
were shown in the range however I can’t figure out how to add the minutes
that are below each instance in the same function. Can this be done?