| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using more than one column for criteria
Hi, I have the following question. I need to add the following:
If Column A has a "P" in it and Column B has "mbc" in it then I need Column C to add. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using more than one column for criteria
You can either use an array formula or sumproduct. Here is sumproduct...
=sumproduct(--($A$1:$A$10 = "P"), --($B$1:$B$10 = "mbc"), $C$1:$C$10) Here is a link that explains the formula... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Lori" wrote: Hi, I have the following question. I need to add the following: If Column A has a "P" in it and Column B has "mbc" in it then I need Column C to add. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using more than one column for criteria
Thank you, worked perfectly!
"Jim Thomlinson" wrote: You can either use an array formula or sumproduct. Here is sumproduct... =sumproduct(--($A$1:$A$10 = "P"), --($B$1:$B$10 = "mbc"), $C$1:$C$10) Here is a link that explains the formula... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Lori" wrote: Hi, I have the following question. I need to add the following: If Column A has a "P" in it and Column B has "mbc" in it then I need Column C to add. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| Counting items in one column based on criteria in another column | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Linear Mode
