Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra

=sumif(a:a,""&x17,b:b)
or
=sumif(a:a,x17,b:b)





Alexandra Lopes wrote:

Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra

--

Dave Peterson

Hello Dave,

I'm using the Conditional Sum:


{=SOMA(SE($C$3:$C$12=D18;$D$3:$D$12;0))},but if I write D18 as the
condition the result is zero...because the formula assumes D18 as a
value, and not as a cell.






Dave Peterson wrote:
=sumif(a:a,""&x17,b:b)
or
=sumif(a:a,x17,b:b)





Alexandra Lopes wrote:
Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra

If D18 was a text value it would be surrounded in quote marks.
{=SOMA(SE($C$3:$C$12=D18;$D$3:$D$12;0))} is different from
{=SOMA(SE($C$3:$C$12="D18";$D$3:$D$12;0))}
--
David Biddulph


"Alexandra Lopes" wrote in message
...
Hello Dave,

I'm using the Conditional Sum:


{=SOMA(SE($C$3:$C$12=D18;$D$3:$D$12;0))},but if I write D18 as the
condition the result is zero...because the formula assumes D18 as a value,
and not as a cell.






Dave Peterson wrote:
=sumif(a:a,""&x17,b:b)
or
=sumif(a:a,x17,b:b)





Alexandra Lopes wrote:
Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra

I don't think so.

My bet is that you're trying to compare digits--and the values in C3:C12 and the
value in D18 are different.

Maybe there's a difference you don't see because of the formatting--c3 could
contain 1, but D18 could be 1.0000000000001 (but formatted to show 1).

Maybe the values in C3:C12 are real numbers, but the value in D18 is text that
looks like numbers.

If you put this in a helper range (E3:E12???):
=c3=$d$18
and drag down, do you see any TRUE's?

======
ps. You may want to look at the equivalent of the English function =sumif().
It doesn't require the array entering (ctrl-shift-enter).



Alexandra Lopes wrote:

Hello Dave,

I'm using the Conditional Sum:

{=SOMA(SE($C$3:$C$12=D18;$D$3:$D$12;0))},but if I write D18 as the
condition the result is zero...because the formula assumes D18 as a
value, and not as a cell.

Dave Peterson wrote:
=sumif(a:a,""&x17,b:b)
or
=sumif(a:a,x17,b:b)





Alexandra Lopes wrote:
Hello,

I'm using the Conditional Sum Wizard.I want to set a condition
indicating a cell and not a value. How do I do it?

Thanks in advanced.

Alexandra


--

Dave Peterson