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!

A rather broad question. Why not Google with the search term: Excel database
This looks useful:
http://www.bristol.ac.uk/is/learning...excelxp-t5.doc
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rosie36" wrote in message
...
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!

--
John


"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!

When I preform a column Summation Function the result is not accurate. What
am I not doing that causes an inaccurate result of this very basic function?
--
John


"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!

How much is "not accurate"?

A penny or two or a great lump?

Show us a sample of your data and the summation formula in use.


Gord Dibben MS Excel MVP

On Sat, 14 Jul 2007 15:56:00 -0700, John wrote:

When I preform a column Summation Function the result is not accurate. What
am I not doing that causes an inaccurate result of this very basic function?

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

"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!

Thank you D
ebra. But what I need to do is to exclude one product from the total and if
I enter the items name in the criteria area this just counts the number of
sales for that product. Have you got any more suggesions as I realise you
know what I am trying to do!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

"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

"rosie36" wrote:



"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

Thank you Debra - you're a star!!!!!!!!!! It works.

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

The criteria that I showed you, with the < in front of the product name:

Product
<Pencil

will exclude one product. Did you try it?

rosie36 wrote:

"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!


Thank you D
ebra. But what I need to do is to exclude one product from the total and if
I enter the items name in the criteria area this just counts the number of
sales for that product. Have you got any more suggesions as I realise you
know what I am trying to do!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html