| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the & symbol in a formula do?
I an looking at a SUMIF formula that includes the & symbol. See below. What
does the & symbol do? =SUMIF($AN$6:$AY$6,"<="&$D$5,AN8:AY8) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the & symbol in a formula do?
It's a concatenation function
Basically combines data So "A"&"B" becomes AB "A "&"B" becomes A B etc "Dominic" wrote: I an looking at a SUMIF formula that includes the & symbol. See below. What does the & symbol do? =SUMIF($AN$6:$AY$6,"<="&$D$5,AN8:AY8) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the & symbol in a formula do?
It tells SUMIF to use what's in cell D5 instead of looking for the text
string "D5" =SUMIF($AN$6:$AY$6,"<=$D$5",AN8:AY8) would look in AN6:AY6 for the text string -- Regards, Peo Sjoblom "Dominic" wrote in message ... I an looking at a SUMIF formula that includes the & symbol. See below. What does the & symbol do? =SUMIF($AN$6:$AY$6,"<="&$D$5,AN8:AY8) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of ^ symbol in a formula | Excel Worksheet Functions | |||
| What does a ^ symbol mean used in a formula | Excel Discussion (Misc queries) | |||
| What does the $ symbol mean in a formula? | New Users to Excel | |||
| Using a Symbol in a formula. | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Linear Mode
