Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 81
Default SumIf with date range

I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if it's
value is greater than or equal to the value of the CurDate. If it is then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default SumIf with date range

Try it like this:

=SUMIF(Details!AE$1:BQ$1,"="&CurDate,Details!AE2: BQ2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if it's
value is greater than or equal to the value of the CurDate. If it is then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 81
Default SumIf with date range

Works Great...thank you!!! One question...why do I need the quotes around
the = instead of around the entire calculation? I'd like to understand why
it works now and not before. Thanks again.

"T. Valko" wrote:

Try it like this:

=SUMIF(Details!AE$1:BQ$1,"="&CurDate,Details!AE2: BQ2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if it's
value is greater than or equal to the value of the CurDate. If it is then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default SumIf with date range

That's just one of Excel's quirks!

If the criteria is a hardcoded number:

=SUMIF(range1,"=10",range2)
=SUMIF(range1,100,range2)

If the criteria is hardcoded text:

=SUMIF(range1,"X",range2)

If the criteria is a cell reference or a named cell:

=SUMIF(range1,"="&A1,range2)
=SUMIF(range1,"="&CurDate,range2)
=SUMIF(range1,CurDate,range2)
=SUMIF(range1,A1,range2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
Works Great...thank you!!! One question...why do I need the quotes around
the = instead of around the entire calculation? I'd like to understand
why
it works now and not before. Thanks again.

"T. Valko" wrote:

Try it like this:

=SUMIF(Details!AE$1:BQ$1,"="&CurDate,Details!AE2: BQ2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if
it's
value is greater than or equal to the value of the CurDate. If it is
then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 81
Default SumIf with date range

Thank you



"T. Valko" wrote:

That's just one of Excel's quirks!

If the criteria is a hardcoded number:

=SUMIF(range1,"=10",range2)
=SUMIF(range1,100,range2)

If the criteria is hardcoded text:

=SUMIF(range1,"X",range2)

If the criteria is a cell reference or a named cell:

=SUMIF(range1,"="&A1,range2)
=SUMIF(range1,"="&CurDate,range2)
=SUMIF(range1,CurDate,range2)
=SUMIF(range1,A1,range2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
Works Great...thank you!!! One question...why do I need the quotes around
the = instead of around the entire calculation? I'd like to understand
why
it works now and not before. Thanks again.

"T. Valko" wrote:

Try it like this:

=SUMIF(Details!AE$1:BQ$1,"="&CurDate,Details!AE2: BQ2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if
it's
value is greater than or equal to the value of the CurDate. If it is
then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?









  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default SumIf with date range

You're welcome!

--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
Thank you



"T. Valko" wrote:

That's just one of Excel's quirks!

If the criteria is a hardcoded number:

=SUMIF(range1,"=10",range2)
=SUMIF(range1,100,range2)

If the criteria is hardcoded text:

=SUMIF(range1,"X",range2)

If the criteria is a cell reference or a named cell:

=SUMIF(range1,"="&A1,range2)
=SUMIF(range1,"="&CurDate,range2)
=SUMIF(range1,CurDate,range2)
=SUMIF(range1,A1,range2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
Works Great...thank you!!! One question...why do I need the quotes
around
the = instead of around the entire calculation? I'd like to
understand
why
it works now and not before. Thanks again.

"T. Valko" wrote:

Try it like this:

=SUMIF(Details!AE$1:BQ$1,"="&CurDate,Details!AE2: BQ2)


--
Biff
Microsoft Excel MVP


"juliejg1" wrote in message
...
I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine
if
it's
value is greater than or equal to the value of the CurDate. If it
is
then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any
suggestions?









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif date range Delsy Excel Worksheet Functions 6 March 22nd 12 06:51 PM
Sumif for Date Range Raza Excel Discussion (Misc queries) 3 April 11th 07 04:32 PM
Sumif with two criteria including a date range Ladyofthewhitecity Excel Discussion (Misc queries) 4 February 4th 07 10:53 AM
SUMIF within date range as a function of today()'s date irvine79 Excel Worksheet Functions 8 August 6th 06 05:55 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"