=SUMPRODUCT((MONTH(A1:A10)=12)*(YEAR(A1:A10)=2009 )*(B1:B10))
I tried to remove the year part of the
statement but got an error message.

Try this...

=SUMPRODUCT(--(MONTH(A1:A10)=12),B1:B10)

--
Biff
Microsoft Excel MVP


"
m wrote in message
...
That's great. However, I would like to do the summing irrespective of the
year. I am trying to show a multi year trend with the data displayed only
by
the month. In this case the total number of dollars spent a certain month
with five year spread. I don't care what the year is, only the cumulative
amount that was spent in each of the 12 months. I tried to remove the
year
part of the statement but got an error message. I've never done array
calculations before, so consider me ignorant of how they operate.

Thanks

Samm

"Mike H" wrote:

Hi,

Try this

=SUMPRODUCT((MONTH(A1:A10)=12)*(YEAR(A1:A10)=2009) *(B1:B10))

Mike

" wrote:

I have one column of dates and a second column of costs. How would I
sum all
of the particular costs for a certain month.