Thank you for your help.

"Bob Phillips" wrote:

=SUMPRODUCT(--(TEXT(A2:A25,"yyyymmm")="2005Jan"),--(M2:M25="Operators"),D2:D
25)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Excel date function" wrote in
message ...
How could this formula be modified to include a second group of text (in
M2:M25 called Operators) so I could group by date and Operators and then
add
the amounts in D2:D25?

"Bob Phillips" wrote:

=SUMPRODUCT(--(TEXT(A2:A25,"yyyymmm")="2005Jan"),D2:D25)

--
HTH

Bob Phillips

"Excel date range function" <Excel date range
wrote in message
...
I have created the function SUMIF(A2:A25,"1/10/05",D2:D25) where the
entries
of the A column are dates and the D column are amounts. For every
entry
on
1/10/05, it totals the amount. How can I apply this function with a
date
range criteria of one month instead of just one day?