LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default database function

I do not know what you mean by "Area west"

"K11ngy" wrote:

Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve



 
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
help with database function andresg1975 Excel Worksheet Functions 1 November 8th 06 09:38 PM
Reporting with Database function tabediako Excel Discussion (Misc queries) 1 August 3rd 06 05:38 PM
Database function criteria Maistrye Excel Worksheet Functions 0 July 5th 06 09:57 PM
Database function that sums? Keensie Excel Discussion (Misc queries) 3 April 25th 06 03:38 PM
How does the Database Function work in Excel Jacquelynn Excel Worksheet Functions 3 June 4th 05 09:32 PM


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

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

About Us

"It's about Microsoft Excel"