| 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. |
| 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 | |||
Threaded Mode
