Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif date range | Excel Worksheet Functions | |||
Sumif for Date Range | Excel Discussion (Misc queries) | |||
Sumif with two criteria including a date range | Excel Discussion (Misc queries) | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |