| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
| Wrap text doesn't wrap | Excel Worksheet Functions | |||
| Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Linear Mode
