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

[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!

 

[T. Valko]

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)

 

[yawnmoth]

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.

 

[Glenn]

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.

 

[T. Valko]

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)

I get zero in both cases.