software

I am trying to debug a spreadhseet and have come across this formula in
the middle of a sumif calc:

quot;=quot;amp;$C13

I am struggling with the quot;=quot; and the amp;. Can someone provide some
guidance?--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: www.excelforum.com/member.php...oamp;userid=30986
View this thread: www.excelforum.com/showthread...hreadid=522466
If the formula is something like

=SUMIF(A:A,quot;=quot;amp;$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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=522466Like:

=sumif(a1:a10,quot;=quot;amp;$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 quot;=quot; 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,quot;lt;gt;quot;amp;$c13,b1:b10)
=sumif(a1:a10,quot;gt;quot;amp;$c13,b1:b10)
=sumif(a1:a10,quot;lt;quot;amp;$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:
gt;
gt; I am trying to debug a spreadhseet and have come across this formula in
gt; the middle of a sumif calc:
gt;
gt; quot;=quot;amp;$C13
gt;
gt; I am struggling with the quot;=quot; and the amp;. Can someone provide some
gt; guidance?
gt;
gt; --
gt; jcastellano
gt; ------------------------------------------------------------------------
gt; jcastellano's Profile: www.excelforum.com/member.php...oamp;userid=30986
gt; View this thread: www.excelforum.com/showthread...hreadid=522466

--

Dave Peterson