Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance with "="
I am trying to debug a spreadhseet and have come across this formula in the middle of a sumif calc: "="&$C13 I am struggling with the "=" and the &. Can someone provide some guidance? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=522466 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance with "="
If the formula is something like =SUMIF(A:A,"="&$C13,B:B) then that just means that B will be summed when the corresponding entry in A is equal to C13 you could equally use =SUMIF(A:A,$C13,B:B) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=522466 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Assistance with "="
Like:
=sumif(a1:a10,"="&$c13,b1:b10) I think that the originator wanted to be explicit with what he/she was doing. This would have been sufficient: =sumif(a1:a10,$c13,b1:b10) But by including the "=" in that criteria, it would be easy to see how to change it to not equal or greater than or less than: =sumif(a1:a10,"<"&$c13,b1:b10) =sumif(a1:a10,""&$c13,b1:b10) =sumif(a1:a10,"<"&$c13,b1:b10) ===== But the original formula is still just checking each cell in the first range and comparing it to the value in the criteria ($c13) and summing that 2nd range. jcastellano wrote: I am trying to debug a spreadhseet and have come across this formula in the middle of a sumif calc: "="&$C13 I am struggling with the "=" and the &. Can someone provide some guidance? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=522466 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Formula Assistance ( | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
I need assistance with wrting an Excel formula | Excel Worksheet Functions |