Hi guys I've just started trying to learn Excel since it seems a pretty desired skill to have nowadays, I've been practicing for a while and I've been making a series of sheets that list down 15 businesses within a series of cities, now what I'm trying to do is have Excel count how many times the word "Web" has been put down, the thing is I want it to count ONLY the cells with a specific city, so for example there are 15 businesses within Seattle, Memphis, Milwaukee. I want each of them to have the time "Web" has been written down counted out individually, so for example, for Seattle it would be 5, Memphis 3, Milwaukee 2. Is there a way to go about this? All =COUNTIF ways I've tried end up totaling every "Web" it sees down the collums, ignoring the specific cities they're attributed to. Is there a way to set it to look for the city and the "Web" within one formula? Thanks for reading this, it may not make much sense I'm just a little confused, that's all.
P.S I've been using Excel online D: I'm a scrub sorry!
Bookmarks