| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple if functions with sum
I need to embed if and sum functions. I know there is a way of doing this if
you have more than one condition. For example if you wanted to sum if column A had a value of 1 and column b had a value of 2, then sum the column c values. I believe there is an add in but am not too sure how to get it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple if functions with sum
Louisa,
Sumproduct may be a better option =SUMPRODUCT((A1:A1000=1)*(B1:B1000=2)*(C1:C1000)) Mike "louisa" wrote: I need to embed if and sum functions. I know there is a way of doing this if you have more than one condition. For example if you wanted to sum if column A had a value of 1 and column b had a value of 2, then sum the column c values. I believe there is an add in but am not too sure how to get it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Functions | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| multiple IIF functions | Excel Worksheet Functions | |||
| Multiple IF functions | Excel Worksheet Functions | |||
| Multiple IF functions | Excel Worksheet Functions | |||
Linear Mode
