Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database function
I wish to count the number of different products using the database function,
but need to exclude one of the products. Any ideas anyone? Thanks Rosie36 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database function
What do you mean by count them but ignore one? If you count them, just
subtract 1 to ignore 1. Or is there more to it than that? Give some example data and results. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rosie36" wrote in message ... I wish to count the number of different products using the database function, but need to exclude one of the products. Any ideas anyone? Thanks Rosie36 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database function
"Bob Phillips" wrote: What do you mean by count them but ignore one? If you count them, just subtract 1 to ignore 1. Or is there more to it than that? Give some example data and results. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rosie36" wrote in message ... I wish to count the number of different products using the database function, but need to exclude one of the products. Any ideas anyone? Thanks Rosie36 Hi Bob It is a spreadsheet (mock exam) showing a sales report for different products and the sales for each of them. I need to count the number of sales for all the products but excluding one of them (using a database function). It is no problem counting all of them - but how do I exclude one of the items using a database function. How do I show this in the criteria etc? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database function
The criteria that I showed you in your previous post, with the < (not
equal to) in front of the product name: Product <Pencil will exclude one product. rosie36 wrote: I wish to count the number of different products using the database function, but need to exclude one of the products. Any ideas anyone? Thanks Rosie36 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Database function
Just create a criteria section with a heading the same as the product
heading and a value below that of <product_to_be_excluded -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rosie36" wrote in message ... "Bob Phillips" wrote: What do you mean by count them but ignore one? If you count them, just subtract 1 to ignore 1. Or is there more to it than that? Give some example data and results. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rosie36" wrote in message ... I wish to count the number of different products using the database function, but need to exclude one of the products. Any ideas anyone? Thanks Rosie36 Hi Bob It is a spreadsheet (mock exam) showing a sales report for different products and the sales for each of them. I need to count the number of sales for all the products but excluding one of them (using a database function). It is no problem counting all of them - but how do I exclude one of the items using a database function. How do I show this in the criteria etc? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel database function | Excel Worksheet Functions | |||
database function | Excel Discussion (Misc queries) | |||
help with database function | Excel Worksheet Functions | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
How does the Database Function work in Excel | Excel Worksheet Functions |