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