Excel Database function

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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)

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?

 

[Debra Dalgleish]

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.

 

[Bob Phillips]

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)