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?
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?
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)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks