Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF and SUMIFS Error
It seems that I have to concatenate the criteria arguments in the
SUMIF and SUMIFS functions since I have moved to Excel 2007. For example, "D$4" must become ""&D$4 in the Excel 2007 version. Is this a change in syntax or a bug that needs to be addressed. Any thoughts... Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF and SUMIFS Error
See your other post.
On 09/15/2010 08:45, Jim wrote: It seems that I have to concatenate the criteria arguments in the SUMIF and SUMIFS functions since I have moved to Excel 2007. For example, "D$4" must become ""&D$4 in the Excel 2007 version. Is this a change in syntax or a bug that needs to be addressed. Any thoughts... Jim -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF and SUMIFS Error
Even needing to concatenate the "" sign and the cell reference? I am
not sure that I ever remember needing this syntax. Here's another...conditional formatting has been "glitching" around a lot, as well. Have you noticed anything weird with this? I have tried the conditional formatting provided in the program and created it on my own with the cell. For example: =if("D4="Years",E4/F4,text(E4/F4,"0.0%")) This formula works most of the time, but just stops working in some instances until you edit the formula, altering nothing, and recalculate. Same with the conditional formatting functionality built into excel. (Note: I have already verified uniform formatting of the source date.) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF and SUMIFS Error
See your other post.
On 09/16/2010 09:02, Jim wrote: Even needing to concatenate the "" sign and the cell reference? I am not sure that I ever remember needing this syntax. Here's another...conditional formatting has been "glitching" around a lot, as well. Have you noticed anything weird with this? I have tried the conditional formatting provided in the program and created it on my own with the cell. For example: =if("D4="Years",E4/F4,text(E4/F4,"0.0%")) This formula works most of the time, but just stops working in some instances until you edit the formula, altering nothing, and recalculate. Same with the conditional formatting functionality built into excel. (Note: I have already verified uniform formatting of the source date.) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF or SUMIFS help | Excel Worksheet Functions | |||
SumIf or SumIfs or something else? | Excel Worksheet Functions | |||
sumifs, sumif with dates | Excel Worksheet Functions | |||
SUMIF and SUMIFS | Excel Worksheet Functions | |||
SUMIF or SUMIFS | Excel Worksheet Functions |