C
COskibum
I'm trying to sum the numbers in one column that fall within specified date
ranges listed in another column i.e. how many products were produced during a
given quarter throughout a fiscal year. The formula I've created looks
something like:
=SUMIF(L7:L226,"=AND(<9/30/2008,>01/01/2009)",M7:M226)
or basically (SUMIF(dates column,date range condition, numbers column to sum))
I suspect that the problem lies within the formatting for the date range
condition, but I haven't been able to find the proper usage for using a date
range within a condition statement. Anyone out there know how to make this
work?
ranges listed in another column i.e. how many products were produced during a
given quarter throughout a fiscal year. The formula I've created looks
something like:
=SUMIF(L7:L226,"=AND(<9/30/2008,>01/01/2009)",M7:M226)
or basically (SUMIF(dates column,date range condition, numbers column to sum))
I suspect that the problem lies within the formatting for the date range
condition, but I haven't been able to find the proper usage for using a date
range within a condition statement. Anyone out there know how to make this
work?