database function
 

Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve

database function
 

SUMPRODUCT sounds like the best bet.

=SUMPRODUCT((B5:B8)*(B5:B812)*(A5:A8<"West")) for example.
--
David Biddulph

"K11ngy" wrote in message
...
Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve

database function
 

=SUMPRODUCT(--(A2:A20<"West"),--(B2:B2012))

will count them

=SUMPRODUCT(--(A2:A20<"West"),--(B2:B2012),B2:B20)

will sum them

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"K11ngy" wrote in message
...
Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve

database function
 

You could try:-

=SUMPRODUCT((A1:A100<"West")*(B1:B10012),B1:B100 )

Mike

"K11ngy" wrote:

Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve

database function
 

I do not know what you mean by "Area west"

"K11ngy" wrote:

Unsure what database function to use. I have 1 column where I need to add
sales where criteria is 12 but in column to left it must not include the
area west?

Not sure if I use sumif, dsum, countif or another funtion?

the question I am being asked is to count sales greater that 12 but do not
include the area west

Hope someone can help?

regards

Steve