|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Excel database function
"Debra Dalgleish" wrote:
In the criteria range, enter the heading from the product column
In the cell below, use the product name that you want to exclude, e.g.:
Product
<Pencil
rosie36 wrote:
I am doing a mock exam and am trying to do a database function which counts
the number of orders but excludes one of the products. But I just cannot
work out how to show this in the criteria. I'm doing my advance ECDL exam in
10 days and really need to know how to do this in case it crops up!
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Thank you Debra but if I put the item name in the product area in the criteria selection it just counts the number of that product - I need to exclude the product from the total.
Rosie36
|