Extract data based on date?

I have a sheet that has engine running hours in it. Date format is in ddmmyy.
How can I extract and total all the hours in a particular month?
Thanks.

PJ,

please post a workbook. It'll be much easier to figure out and demonstrate.

Say hello to the dolphins from me when you next take the boat out!!

Teylyn

OK here is the sheet.
In short what I want to do is count the hours done over the last 7 , 28 and 90 days . You can see I have formulas that do this on a daily basis but this gives us no historical data . in cell J19 I have the formula but it doesn not like the greater than symbol . The formula works with a date etc . The greater than works in the formulas in cells K L M etc ..
The theory behind the formula I am trying to work is if cells a are greater than date – 7 ( seven days etc ) then add cells E .. Just does not like the greater than part

I assume that what you want to achieve is like a running total of the previous 28 days, so for row 19 you want to look at the total flight hours for the 17/10 to 14/11

You have in J19

=SUMIF(A2:A19, ">(A105-28)", E2:E19)

I don't know what the A105 refers to. Cell A105 is blank.

If you want to do a sum of all flight hours in the last 28 days up to this date, use this formula

=SUMIF($A$3:$A19, ">"&A19-28, $E$3:$E19)

Note how the greater than sign is in quotes and the rest of the condition gets concatenated with the ampersand sign. That's the trick you need to use here.

This formula can be copied up and down into the previous and next rows. It will always sum up 28 days to the current row.

Note please that you have a blank date in A8. This will create some funny calculations. In this list, your dates need to be all filled in, otherwise the formulas will not be able to assess the row's date.

Hope this helps

You did not comment on my mention of boats and dolphins, so you probably aren't who I thought you might be.

cheers

Teylyn

Thanks for that, will give it a go.
"Boats and Dolphins"? Hmm, well I do have a boat............
Who did you think I was ?

I attached your file with your solution.

Hope this is your solution

Rakesh