|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 24th, 2010, 05:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SELECT SUM(h) WHERE e = 'eBay Payment Sent'
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! 
|
|
#2
March 24th, 2010, 05:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SELECT SUM(h) WHERE e = 'eBay Payment Sent'
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" wrote in message ... 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!
|
|
#3
March 24th, 2010, 06:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SELECT SUM(h) WHERE e = 'eBay Payment Sent'
On Mar 24, 12:46*pm, "T. Valko" 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.
|
|
#4
March 24th, 2010, 06:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SELECT SUM(h) WHERE e = 'eBay Payment Sent'
yawnmoth wrote:
On Mar 24, 12:46 pm, "T. Valko" 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.
|
|
#5
March 24th, 2010, 06:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SELECT SUM(h) WHERE e = 'eBay Payment Sent'
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" wrote in message ... On Mar 24, 12:46 pm, "T. Valko" 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
