Combine 2 formulas

S

Steved

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.
 
S

Steved

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)
 
A

Aladin Akyurek

=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)
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)


:

--

[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.
 
S

Steved

Hello Aladin form Steved

I would like to say thankyou verymuch as I like clean formulas such as yours.

Cheers

Aladin Akyurek said:
=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)
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)


:

--

[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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top