conditional sum

[leadplane]

I have a flight logbook, where each row is a flight entry and each column has various data. Column A is the date of flight, column G is the flighttime. On a sepearte page I want to have monthly and cumulative entries. "a5" is a date I want to sum til. I tried this however it didn't work. How can I fix it, or is there something better to use.

=SUMIF(Total!$A$5:$A$2000,"<a5",Total!G$5:G$2000)

 

[Mark W.]

=SUMIF(Total!$A$5:$A$2000,"<"&A5,Total!G$5:G$2000)

BTW, if you gonna include a less than sign in your posting check "Disable HTML on this Post" option or else it will be interpreted as the beginning of a tag, and your formula will be truncated.
This message was edited by Mark W. on 2002-09-06 15:46