database function

[Guest]

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

 

[David Biddulph]

SUMPRODUCT sounds like the best bet.

=SUMPRODUCT((B5:B8)*(B5:B8>12)*(A5:A8<>"West")) for example.

 

[Bob Phillips]

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

will count them

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

will sum them

--
HTH

Bob

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

 

[Guest]

You could try:-

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

Mike

 

[Guest]

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