unable to set the FormulaArray property of the Range class
If I wanted to sum a specific month here is how I might go about it
=SUM(IF(MONTH(A2:A60)=1, B2:B60))
When you enter this it is an array formula so you need to hit Shift + Ctrl
+ Enter, instead of just enter. You will know if it is an array formula
because it will end up with curly braces around it{}.
Or better yet create a pivot table and group on the dates field to aggregate
by months. That is actually a heck of a lot easier if you want to aggregate
based on years, months, quarters... and / or by customer, region, store...
Let me know if you want help giving that a try. It is really easy...
HTH
"jimkozak" wrote:
More information------------
If the selected cells do fall within a date range, corresponding cells, need
to be summed. I am using this to sum items that are shipped in a given month.
"jim kozak" wrote:
Trying to use conditional sum for a range of dates. this used to work in
Excel 95 doesn't seem to work here.
|