Forum Discussion
Help with Countif returning a value if another cell contains text
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 str...
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,
