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:e12de66767d244ed8dc6e92007315ab2(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:805ffc529e1f459799c90e0b66a0a6be(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.. 