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