I have a formula (simplified example) =SUMIFS( A1:A10 , B1:B10 , 3 & "*")
My problem is B1:B10 are numbers and not text. As 3&"*" will always be text I need to convert the range to text. I would really like to to keep the column itself as text and to do the conversion in the formula. However I can't find any text functions that work on an array even (ctr-shift-enter).
Any ideas or thoughts to something like =SUMIFS( maketext(A1:A10) , B1:B10 , 3 & "*")
This is in Excel 365.
thanks
Alan
My problem is B1:B10 are numbers and not text. As 3&"*" will always be text I need to convert the range to text. I would really like to to keep the column itself as text and to do the conversion in the formula. However I can't find any text functions that work on an array even (ctr-shift-enter).
Any ideas or thoughts to something like =SUMIFS( maketext(A1:A10) , B1:B10 , 3 & "*")
This is in Excel 365.
thanks
Alan