+ Reply to Thread
Results 1 to 3 of 3

Formula help

  1. #1
    Registered User
    Join Date
    05-13-2021
    Location
    Newcastle upon tyne
    MS-Off Ver
    O365
    Posts
    1

    Formula help

    Hi all,

    I'll do my best to explain this but I've been asked to do something and I'm not sure on the formula.

    Basically have an excel sheet with rows of data and each row has a unique name a column which has a "Y" or "N" and against each one is a category.

    What I want to do is for the formula to look at each row and if it has a "y" I want it to look at the category and ultimately it needs to produce a donut chart that counts up rows that show "y" and then put them in to a donut showing the total amount in each category.

    Grateful for anyone who can help with this.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,714

    Re: Formula help

    Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,638

    Re: Formula help

    ...in addition, please edit the title so that it meets our requirement as outlined in the rules.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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