Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Calculate Function?
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 todays 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 cant figure out how to add the minutes that are below each instance in the same function. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate function Xx+1=rX(1-X). How? | Excel Discussion (Misc queries) | |||
find the same entries and calculate sum | Excel Worksheet Functions | |||
Find dates to calculate amount of work per day? Possible? | Excel Discussion (Misc queries) | |||
Find duplicates then calculate..??? | Excel Worksheet Functions | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) |