MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Define cell as a condition

• Follow

```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?

Alexandra
```
 0
Reply Alexandra 1/25/2010 4:05:19 PM

```=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
```
 0
Reply Dave 1/25/2010 4:13:34 PM

```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
>
```
 0
Reply Alexandra 1/25/2010 4:31:45 PM

```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" <alopes@telbit.pt> wrote in message
news:OMmDkvdnKHA.4648@TK2MSFTNGP06.phx.gbl...
> 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
>>

```
 0
Reply David 1/25/2010 4:59:49 PM

```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
```
 0
Reply Dave 1/25/2010 5:02:14 PM

4 Replies
336 Views

(page loaded in 0.071 seconds)

Similiar Articles:

7/17/2012 6:16:06 PM