database function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
SUMPRODUCT sounds like the best bet.

=SUMPRODUCT((B5:B8)*(B5:B8>12)*(A5:A8<>"West")) for example.
 
=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)
 
Back
Top