Text Wrap
 

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

Text Wrap
 

You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson

Text Wrap
 

Thankyou.

"Dave Peterson" wrote:

You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson

Text Wrap
 

Hello from Steved

{=SUMPRODUCT(($H$1:$H$1="City"&CHAR(10)&"Depot")*( $A$2:$A$27="M")*$H$2:$H$27)}

City
Depot

What Have I not done to accomplish the above to work in the above formula
please.



"Steved" wrote:

Thankyou.

"Dave Peterson" wrote:

You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson

Text Wrap
 

First, you don't need to array enter the formula.

Maybe...
=if($h$1<"City"&CHAR(10)&"Depot",0,SUMPRODUCT(($A $2:$A$27="M")*$H$2:$H$27))

or maybe...

=($h$1="City"&CHAR(10)&"Depot") * SUMPRODUCT(($A$2:$A$27="M")*$H$2:$H$27)





Steved wrote:

Hello from Steved

{=SUMPRODUCT(($H$1:$H$1="City"&CHAR(10)&"Depot")*( $A$2:$A$27="M")*$H$2:$H$27)}

City
Depot

What Have I not done to accomplish the above to work in the above formula
please.

"Steved" wrote:

Thankyou.

"Dave Peterson" wrote:

You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson


--

Dave Peterson

Text Wrap
 

Hello Dave from Steved

I'm very sorry all your formulas are ok, may be I should invest in reading
lesson.

Thanks for taking timeout.

"Dave Peterson" wrote:

First, you don't need to array enter the formula.

Maybe...
=if($h$1<"City"&CHAR(10)&"Depot",0,SUMPRODUCT(($A $2:$A$27="M")*$H$2:$H$27))

or maybe...

=($h$1="City"&CHAR(10)&"Depot") * SUMPRODUCT(($A$2:$A$27="M")*$H$2:$H$27)





Steved wrote:

Hello from Steved

{=SUMPRODUCT(($H$1:$H$1="City"&CHAR(10)&"Depot")*( $A$2:$A$27="M")*$H$2:$H$27)}

City
Depot

What Have I not done to accomplish the above to work in the above formula
please.

"Steved" wrote:

Thankyou.

"Dave Peterson" wrote:

You can type
....="city(alt-enter)depot")*
and it'll work.

You could also make it a formula
....="city" & char(10) & "depot")*




Steved wrote:

Hello from Steved

Is it possible to use a text wrap in a formula for example

=SUMPRODUCT(($H$1:$H$1="City Depot")*($A$28:$A$29="S")*$H$28:$H$29)

Can I do this or is their something I can add to the above formula for it to
reconize a Text Wrap
City
Depot
Thankyou.

--

Dave Peterson


--

Dave Peterson