Forum Discussion
Question related to sum(Text with Number)
Hello Everyone, I want to sum text with number. Like - IN COLUMN - IN ROW - The answer should be come in cell just written sheet with the help of formula Please help.? ...
Sum in column:
="USD "&SUMPRODUCT(--MID(B1:B6,5,100))
Sum in row:
="USD "&SUMPRODUCT(--MID(A1:F1,5,100))
It works! Thank you so much sir😊😊
Sir, what is the -- ?? and where should i use?
