Forum Discussion
Solved
Formula Excel Help
Hi, I'd like to create a formula which looks at column F and if it contains words, "Jay", "Em" then to go to column B AND C and if they both state 'Complete' or 'NA' then to return words in colum...
Try this formula:
=IF(OR([@[Name]]={"Jay","Em"}), IF(SUM(COUNTIF(Table1[@[Servicing Status]:[Complaint Status]], {"Complete","NA"}))=2, "Case Closed", "Case Open"), "")
(Change Name to the real name of that column)
Sorry couldn't create a separate post.
I have a transaction sheet that calculates income from E33 cells from other sheets. =SUM('Invoice 1:Invoice 20'!E33) is normally working, but I have one sheet that is not cooperating and I get the #REF error and cant figure it out. I have checked cells, sheet, calculation...