Text Wrap Issue
 

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$3 7)}

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