| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combine 2 formulas
Hello from Steved
Please how do I combine the below to give me a total in 1 cell. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Thankyou. |
|
#2
|
|||
|
|||
|
Hello from Steved
I've got the result Thankyou. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898)+SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) "Steved" wrote: Hello from Steved Please how do I combine the below to give me a total in 1 cell. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Thankyou. |
|
#3
|
|||
|
|||
|
=SUMPRODUCT(--ISNUMBER(MATCH('From
Charters'!$A$1:$A$898,{"Papakura","Wiri"},0)),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Steved wrote: Hello from Steved I've got the result Thankyou. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898)+SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) "Steved" wrote: Hello from Steved Please how do I combine the below to give me a total in 1 cell. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Thankyou. -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
|
#4
|
|||
|
|||
|
Hello Aladin form Steved
I would like to say thankyou verymuch as I like clean formulas such as yours. Cheers "Aladin Akyurek" wrote: =SUMPRODUCT(--ISNUMBER(MATCH('From Charters'!$A$1:$A$898,{"Papakura","Wiri"},0)),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Steved wrote: Hello from Steved I've got the result Thankyou. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898)+SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) "Steved" wrote: Hello from Steved Please how do I combine the below to give me a total in 1 cell. =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Papakura"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) =SUMPRODUCT(--('From Charters'!$A$1:$A$898="Wiri"),--('From Charters'!$B$1:$B$898="Period.4"),'From Charters'!$D$1:$D$898) Thankyou. -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you combine 2 or more formulas with different totals? | Excel Discussion (Misc queries) | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| How do I combine the 4 IF formulas into 1 formula | Excel Worksheet Functions | |||
| How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
Linear Mode
