Excel Database function

R

rosie36

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
 
B

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)
 
R

rosie36

Bob Phillips said:
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)
Click to expand...

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?
 
D

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.
 
B

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)
 
Top