LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jamdmd
 
Posts: n/a
Default functions on imported database


HI....I have tried to use a sum(if()) function on data that has been
imported using a sql query. The simple sumif function works fine,
but when I try to use multiple criteria I get a 0. Is there a problem
using the sum(if()) on this type of data?..........thanks....jim


--
jamdmd
------------------------------------------------------------------------
jamdmd's Profile: http://www.excelforum.com/member.php...o&userid=35142
View this thread: http://www.excelforum.com/showthread...hreadid=549013

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel database statistical functions (DSUM etc..) CraigS Excel Discussion (Misc queries) 1 March 28th 06 06:19 AM
database functions in excel GoBobbyGo Excel Discussion (Misc queries) 4 October 21st 05 08:08 PM
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
Database Functions - question using formulas as criteria msnews.microsoft.com Excel Worksheet Functions 0 June 9th 05 12:10 PM
Pick certain rows from database to use statistical functions on th Matzon Excel Worksheet Functions 0 March 24th 05 11:03 AM


All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"