SUMIF and Named ranges

[Henry]

How can I get this formula to work. The idea is to create a dynamic formula
where the it sums a range based on the date as it changes each month. e.g.

=SUMIF(Dates,"<=Currentmonthend",revenue)
=SUMIFS(revenue,Dates,"<=Currentmonthend")

neither works, it will work if I substituted a proper date such as
03/31/2009 for currentmonthend, whenever greater than or less than sign is
involved it does not work. Any ideas? Thanks.

Henry

 

[Chip Pearson]

Take the name out of the quoted string. E.g,

=SUMIF(Dates,"<="&CurrentMonthEnd)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Chip Pearson]

Take the name out of the quoted string. E.g,

=SUMIF(Dates,"<="&CurrentMonthEnd)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[T. Valko]

If you have a cell named Currentmonthend that holds the criteria try it like
this:

=SUMIF(Dates,"<="&Currentmonthend,revenue)

 

[T. Valko]

If you have a cell named Currentmonthend that holds the criteria try it like
this:

=SUMIF(Dates,"<="&Currentmonthend,revenue)

 

[Dave Peterson]

Try:

=SUMIF(Dates,"<="&Currentmonthend,revenue)
=SUMIFS(revenue,Dates,"<="&Currentmonthend)

 

[Dave Peterson]

Try:

=SUMIF(Dates,"<="&Currentmonthend,revenue)
=SUMIFS(revenue,Dates,"<="&Currentmonthend)