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

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

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?

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

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?