Forum Discussion
IF, SUMIF or SUMIFS help
Hi all If column A has text (any text), then the value in column B is the same as a specific cell in column B, otherwise leave cell empty. Any ideas? 🙂 Thank you! 💖
gminii Your question is rather vague, but suppose the specific cell in B is B100, the following formula will look for the type of content in A1. Anything other than a text will return a blank, otherwise it returns whatever is in B100.
=IF(ISNONTEXT(A1),"",$B$100)If this is complete nonsense to you, please clarify your needs.