|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 15th, 2002, 08:15 PM
|
#1 |
|
Board Regular
Join Date: May 2002
Posts: 74
|
Is it possible to use the conditional sum wizard to create a formula that will sum the total sales in one column and mulitple conditions from another column? Currently I can only get it to work with one condition.
I need it to add all the sales in colum (D) if my customer column (A) indicates any of the following: Contract Contract-new Contract-Color Upgrade Contract-Size Upgrade Contract-Verbal Basically I need it to calculate any order that is still in need of a contract, for each sales territory, seperately from the overall sales and I cannot get it to work using the conditional sum wizard. |
|
|
|
May 15th, 2002, 08:20 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
Try something like:
=SUM(ISNUMBER(FIND("Contract",A1:A100))*D1:D100) If you have a lot of records, or some other conditions, you may want to use DSUM or a Pivot Table. _________________ Regards, Juan Pablo G. MrExcel.com Consulting [ This Message was edited by: Juan Pablo G. on 2002-05-15 19:22 ] |
|
|
|
|
May 15th, 2002, 08:20 PM
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
Forgot to mention, that that formula is an Array Formula, enter it with Control Shift Enter, not just Enter.
|
|
|
|
|
May 16th, 2002, 12:03 AM
|
#4 |
|
Board Regular
Join Date: Apr 2002
Posts: 113
|
Use the conditional sum wizard add-in to create various formulas and then manually edit them to see how they work. Can edit to use min, max etc. (Rememeber to use CRTL-SHIFT-ENTER) Search help & excel sites for "array formulas"
Tools>Addins>ConditionalSum then Tools>Wizard>conditionalSum |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
