S
Steved
Hello from Steved
The Below works as it should.
{=SUMPRODUCT((BusType!$K$1:$K$1<="Wiri"&CHAR(10)&"Depot")*(BusType!$A$3:$A$37="M")*BusType!$K$3:$K$37)}
I'm having a problem with <="Shore"&CHAR(10)&"Depot"
<="Orewa"&CHAR(10)&"Depot" PleaseWhat is reqiured to below to make it work.
Thankyou.
{=SUMPRODUCT((BusType!$L$1:$M$1={"Shore Depot","Orewa
Depot"})*(BusType!$A$3:$A$37="M")*BusType!$L$3:$M$37)}
The Below works as it should.
{=SUMPRODUCT((BusType!$K$1:$K$1<="Wiri"&CHAR(10)&"Depot")*(BusType!$A$3:$A$37="M")*BusType!$K$3:$K$37)}
I'm having a problem with <="Shore"&CHAR(10)&"Depot"
<="Orewa"&CHAR(10)&"Depot" PleaseWhat is reqiured to below to make it work.
Thankyou.
{=SUMPRODUCT((BusType!$L$1:$M$1={"Shore Depot","Orewa
Depot"})*(BusType!$A$3:$A$37="M")*BusType!$L$3:$M$37)}