|
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 03:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com