Previous 6 months data

[highflyer2509]

I have a logbook for my flight times and how they each breakdown. I have seen formulas for previous 6 month data but I have not been able to find one that pulls a column of data and sums it on a separate page. My dates are in column A and my data are in the next couple of columns. Any Help would be appreciated

[rylo]

Hi

Past 6 Months!A2: =IFERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A:$A>EOMONTH(NOW(),-6),ROW(Sheet1!A:A),""),ROW())),"") Array enter the formula (Ctrl, shift, enter) and copy across / down as required.

rylo

[highflyer2509]

rylo thanks for the effort but either I don't know what I am doing or the formula doesn't work. let me know if im an idiot or if something in the formula needs tweaked
either way thanks

[Kevin UK]

Hi

May be SUMIFS.

[rylo]

Hi

Try putting up some example data that actually falls in the last 6 months. When I looked at your example file, it didn't have any and I had to make some up.

rylo