| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with database function | Excel Worksheet Functions | |||
| Reporting with Database function | Excel Discussion (Misc queries) | |||
| Database function criteria | Excel Worksheet Functions | |||
| Database function that sums? | Excel Discussion (Misc queries) | |||
| How does the Database Function work in Excel | Excel Worksheet Functions | |||
Linear Mode
