DSUM for date range
Can I use the DSUM feature to look at a data sheet and return the sum of all
values which occurred in a given month? Example:
Fields - Date Premium etc.
I want to look at the date field and find for each month what the total
premium are.
I started with DSUM('2004'!$A$6:$AI$471, Premium, ???????)
Not sure how to word the rest. An "If" statement, maybe?
Any ideas would be helpful.
Thanks,
Ken Ivins
|