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?

You could set up a column that will give you the month of the data in column
A. (e.g. =month(A2)). If the data is "1/10/05" it will return the result of
"1". Then you can change your sumif formula to reference the new column with
the months.

"Excel date range function" wrote:

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?

=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?

Thanks, it works great.

"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?

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?

=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?

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?