Excel date function

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
function@discussions.microsoft.com> wrote in message
news:4209FC62-EC04-47AF-9682-E28045A300B6@microsoft.com...
> 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
> function@discussions.microsoft.com> wrote in message
> news:4209FC62-EC04-47AF-9682-E28045A300B6@microsoft.com...
> > 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
> function@discussions.microsoft.com> wrote in message
> news:4209FC62-EC04-47AF-9682-E28045A300B6@microsoft.com...
> > 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" <Exceldatefunction@discussions.microsoft.com> wrote in
message news:F2C7C22E-CA01-4E8C-A484-437981BDB8A8@microsoft.com...
> 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
> > function@discussions.microsoft.com> wrote in message
> > news:4209FC62-EC04-47AF-9682-E28045A300B6@microsoft.com...
> > > 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" <Exceldatefunction@discussions.microsoft.com> wrote in
> message news:F2C7C22E-CA01-4E8C-A484-437981BDB8A8@microsoft.com...
> > 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
> > > function@discussions.microsoft.com> wrote in message
> > > news:4209FC62-EC04-47AF-9682-E28045A300B6@microsoft.com...
> > > > 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?
> > >
> > >
> > >
>
>
>