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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what is ^ in a formula for 2
Excel formula ^ 1
Excel Count If Formula Question 1
what does "^" symbol mean in excel 2
$ Symbol 3
Help with formula 1
How do I create a click on + symbol to open a root and click on -. 1
Sumif less than x 3

Top