Help with Countif returning a value if another cell contains text

%3CLINGO-SUB%20id%3D%22lingo-sub-2128347%22%20slang%3D%22en-US%22%3EHelp%20with%20Countif%20returning%20a%20value%20if%20another%20cell%20contains%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128347%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20getting%20a%20value%20if%20a%20cell%20contains%20text.%20Calculation%20should%20be%20if%20one%20cell%20has%20text%20then%20it%20shows%20a%20value%20from%20another%20cell%2C%20if%20the%20cell%20doesn't%20contain%20the%20text%20then%20it%20counts%20a%20string%20containing%20a%20specific%20text%20value.%20In%20example%20where%20N%2FA%20appears%2C%20score%20achieved%20should%20equal%20goal%2C%20if%20not%20then%20score%20achieved%20should%20count%20the%20values%20of%20Y%20in%20the%20four%20cells%20prior%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2262Mojo_0-1613139354092.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254497i4A2CF14BA530CEB3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%2262Mojo_0-1613139354092.png%22%20alt%3D%2262Mojo_0-1613139354092.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2128347%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2128795%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20with%20Countif%20returning%20a%20value%20if%20another%20cell%20contains%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128795%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F964874%22%20target%3D%22_blank%22%3E%4062Mojo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhere%3F%20Which%20cell%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EFrom%20which%20cell%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhy%20not%20a%20worksheet%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I need help with getting a value if a cell contains text. Calculation should be if one cell has text then it shows a value from another cell, if the cell doesn't contain the text then it counts a string containing a specific text value. In example where N/A appears, score achieved should equal goal, if not then score achieved should count the values of Y in the four cells prior

 

62Mojo_0-1613139354092.png

 

4 Replies

@62Mojo 

Where? Which cell? from which cell?

Why not a worksheet?

 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

 

@NikolinoDE 

 

Thanks for the response. this is a copy of the worksheet that I would like to get the formula for. I'm an amateur at this so bear with me.

 

the cells highlighted in yellow is what i've attempted. the gray is one of the rows that I would like to get the results for the calculation. 

 

thanks,

@62Mojo Try this (also in attached):

=IF(H7="N/A",I7,COUNTIF(J7:M7,"Y"))

@mtarler 

 

That's perfect. Thank you for the help.