D Dominic Apr 24, 2008 #1 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)
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 Apr 24, 2008 #2 It's a concatenation function Basically combines data So "A"&"B" becomes AB "A "&"B" becomes A B etc
P Peo Sjoblom Apr 24, 2008 #3 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
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
