Hi,
Column A contains dates and column B contains numbers, they are both an array named 'flight_date' and 'flight_hours' respectively. In cell C1 I would like to enter a start date, and cell C2 an end date, and have cell C3 sum the total flight hours in between and including the 2 dates.
I tried the below formula but it keeps returning 0.0. Am not really sure how to do this.
{=SUMIF(flight_date,"<="&$C$2,flight_hours)-SUMIF(flight_date,"<"&$C$1,flight_hours)}
Hopefully someone can help.
Thanks,
Paul.
Column A contains dates and column B contains numbers, they are both an array named 'flight_date' and 'flight_hours' respectively. In cell C1 I would like to enter a start date, and cell C2 an end date, and have cell C3 sum the total flight hours in between and including the 2 dates.
I tried the below formula but it keeps returning 0.0. Am not really sure how to do this.
{=SUMIF(flight_date,"<="&$C$2,flight_hours)-SUMIF(flight_date,"<"&$C$1,flight_hours)}
Hopefully someone can help.
Thanks,
Paul.