SELECT SUM(h) WHERE e = 'eBay Payment Sent'

  • Thread starter Thread starter yawnmoth
  • Start date Start date
Y

yawnmoth

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!
 
The following didn't work:
=SUMIF(E2:E542,"=eBay Payment Sent",H2:H542)
Click to expand...

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)
 
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)
Click to expand...

I get zero in both cases.
 
yawnmoth said:
I get zero in both cases.
Click to expand...


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.
 
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


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)
Click to expand...

I get zero in both cases.
 
Back
Top