Nomis_Eswod
Board Regular
- Joined
- Jul 27, 2005
- Messages
- 153
Hi,
I have a spreadsheet, with 2 columns that I'm trying to SUMIF. Column F is amount, and column G is date. I need to SUM column F if the date in column G falls between 2 dates, say 1/1/05 and 31/3/05.
Any ideas on how I can do this??
It would also be good to have the criteria as cell references, so that if I need to change either of the dates, the SUMIF will be calculated automatically.
Any help appreciated!
I have a spreadsheet, with 2 columns that I'm trying to SUMIF. Column F is amount, and column G is date. I need to SUM column F if the date in column G falls between 2 dates, say 1/1/05 and 31/3/05.
Any ideas on how I can do this??
It would also be good to have the criteria as cell references, so that if I need to change either of the dates, the SUMIF will be calculated automatically.
Any help appreciated!