View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yawnmoth yawnmoth is offline
external usenet poster
 
Posts: 3
Default 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!