If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|