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?