What does the & symbol in a formula do?

D

Dominic

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

akphidelt

It's a concatenation function

Basically combines data

So

"A"&"B" becomes AB
"A "&"B" becomes A B
etc
 
P

Peo Sjoblom

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
 
Top