Prev: Date Formatting
Next: adding result of "if" statement..
From: yawnmoth on 24 Mar 2010 13:22
If SQL queries could be performed in Excel, I'd do "SELECT SUM(h)
WHERE e = 'eBay Payment Sent'". Since SQL doesn't support SQL,
however, I need to try something else. The following didn't work:

=SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)

Any ideas what will work?

Thanks!
From: T. Valko on 24 Mar 2010 13:46
>The following didn't work:
>=SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)

What does "didn't work" mean? You get an error? An incorrect result? No
result?

The formula syntax is correct so that eliminates the formula as a problem.
So, that means there's a problem with the data.

See if this works...

=SUMPRODUCT(--(ISNUMBER(SEARCH("eBay Payment Sent",E2:E542))),H2:H542)

--
Biff
Microsoft Excel MVP


"yawnmoth" <terra1024(a)yahoo.com> wrote in message
news:e12de667-67d2-44ed-8dc6-e92007315ab2(a)15g2000yqi.googlegroups.com...
> If SQL queries could be performed in Excel, I'd do "SELECT SUM(h)
> WHERE e = 'eBay Payment Sent'". Since SQL doesn't support SQL,
> however, I need to try something else. The following didn't work:
>
> =SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)
>
> Any ideas what will work?
>
> Thanks!


From: yawnmoth on 24 Mar 2010 14:16
On Mar 24, 12:46 pm, "T. Valko" <biffinp...(a)comcast.net> wrote:
> >The following didn't work:
> >=SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)
>
> What does "didn't work" mean? You get an error? An incorrect result? No
> result?
>
> The formula syntax is correct so that eliminates the formula as a problem..
> So, that means there's a problem with the data.
>
> See if this works...
>
> =SUMPRODUCT(--(ISNUMBER(SEARCH("eBay Payment Sent",E2:E542))),H2:H542)

I get zero in both cases.
From: Glenn on 24 Mar 2010 14:41
yawnmoth wrote:
> On Mar 24, 12:46 pm, "T. Valko" <biffinp...(a)comcast.net> wrote:
>>> The following didn't work:
>>> =SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)
>> What does "didn't work" mean? You get an error? An incorrect result? No
>> result?
>>
>> The formula syntax is correct so that eliminates the formula as a problem.
>> So, that means there's a problem with the data.
>>
>> See if this works...
>>
>> =SUMPRODUCT(--(ISNUMBER(SEARCH("eBay Payment Sent",E2:E542))),H2:H542)
>
> I get zero in both cases.


The data in column H could be text that looks like a number. Put the number 1
in an unused cell and then copy it. Select you data in column H and then Edit /
Paste Special / Values / Multiply / OK.
From: T. Valko on 24 Mar 2010 14:42
>I get zero in both cases.

Ok, we're narrowing it down!

What result do you get with this formula?

=COUNT(H2:H542)

That will count only *true Excel numbers* in the range. If you get a result
of 0 then your numbers aren't true numeric values.

--
Biff
Microsoft Excel MVP


"yawnmoth" <terra1024(a)yahoo.com> wrote in message
news:805ffc52-9e1f-4597-99c9-0e0b66a0a6be(a)z4g2000yqa.googlegroups.com...
On Mar 24, 12:46 pm, "T. Valko" <biffinp...(a)comcast.net> wrote:
> >The following didn't work:
> >=SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)
>
> What does "didn't work" mean? You get an error? An incorrect result? No
> result?
>
> The formula syntax is correct so that eliminates the formula as a problem.
> So, that means there's a problem with the data.
>
> See if this works...
>
> =SUMPRODUCT(--(ISNUMBER(SEARCH("eBay Payment Sent",E2:E542))),H2:H542)

I get zero in both cases.


 | 
Pages: 1
Prev: Date Formatting
Next: adding result of "if" statement..