+ Reply to Thread
Results 1 to 5 of 5

Cant figure out the correct way to go about a formula

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Secret
    MS-Off Ver
    2015
    Posts
    4

    Cant figure out the correct way to go about a formula

    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!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    07-27-2015
    Location
    Secret
    MS-Off Ver
    2015
    Posts
    4

    Re: Cant figure out the correct way to go about a formula

    I also realize this is probably such a stupid question, sorry..

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Cant figure out the correct way to go about a formula

    It's not a stupid question.

    Use COUNTIFS
    e.g.
    =COUNTIFS(A1:A100,"Web",B1:B100,"Tauranga")
    would count the number of times "Web" appears in the range A1:A100 but only if column B of that row contains "Tauranga"

    You probably want something more like
    =COUNTIFS(A1:A100,"Web",B1:B100,G2)

    as column G contains the city.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    07-27-2015
    Location
    Secret
    MS-Off Ver
    2015
    Posts
    4

    Re: Cant figure out the correct way to go about a formula

    Ohhh I'll be sure to give that a try I was using this =SUM(IF(B2:B16="Tauranga", IF(C2:C16="Web",1,0),0)) however it kept printing out 0... So we'll see if your solution works, thank you!!

  5. #5
    Registered User
    Join Date
    07-27-2015
    Location
    Secret
    MS-Off Ver
    2015
    Posts
    4

    Re: Cant figure out the correct way to go about a formula

    It worked ;-; thank you, you've really helped me out a bunch... I was so confused.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 15
    Last Post: 11-25-2014, 08:14 AM
  2. Replies: 3
    Last Post: 10-10-2014, 08:14 AM
  3. [SOLVED] Trying to figure out a way to correct dates in 8000 line spreadsheet
    By ppilot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-10-2014, 05:27 PM
  4. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  5. [SOLVED] Bar Chart Data label % figure not correct
    By Lsinshirley in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2013, 09:59 AM
  6. Sum formula to exclude monthly budget figure when actual figure is entered
    By rocketmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 04:22 AM
  7. [SOLVED] A correct formula gives an incorrect figure
    By GarMcCas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2006, 06:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1