Excel date function

[Excel date range function]

I have created the function SUMIF(A2:A25,"1/10/05",D225) 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?

 

[QC Coug]

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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

"Excel date range function" <Excel date range
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Excel date function]

Thanks, it works great.

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

--
HTH

Bob Phillips

"Excel date range function" <Excel date range
(e-mail address removed)> wrote in message

 

[Excel date function]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Excel date function]

Thank you for your help.

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

--

HTH

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