Categories
User Help Web Apps

How can I include text from a cell within a COUNTIF function in Google Sheets?

I am using sheets to mark quiz responses. I am trying to display a 1 if the answer contains a certain string (therefore, is correct). For example, COUNTIF(d2, “*serbia”). So, if D2 contains this text, display a 1. However, I want to get the text “serbia” (for example) from another cell. So a separate cell […]