+ Reply to Thread
Results 1 to 4 of 4

Excel formula to summarize, count and label

  1. #1
    Registered User
    Join Date
    12-15-2016
    Location
    Southern California
    MS-Off Ver
    2016
    Posts
    2

    Excel formula to summarize, count and label

    Greetings

    I am trying to figure out how to take data that is in one worksheet in a column that has entries such as Small Room; Medium Room; Large Room etc. There are several random entries in this column of said fields and I want to summarize that data, count it and label it on a different worksheet. The output would be something like this:

    Small Room 2
    Medium Room 4
    Large Room 1

    Is this possible and if so....how?

    Thanks for the assistance

    Charles

  2. #2
    Banned User!
    Join Date
    03-06-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    295

    Re: Excel formula to summarize, count and label

    If you can attach the file I will see what I can do to help you. Go Advanced and then Manage Attachments and upload the file.

  3. #3
    Registered User
    Join Date
    12-15-2016
    Location
    Southern California
    MS-Off Ver
    2016
    Posts
    2

    Re: Excel formula to summarize, count and label

    File attached....I think
    Attached Files Attached Files

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,550

    Re: Excel formula to summarize, count and label

    Here is an example file that will get you going (attached):
    .
    .
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Macro count items in sheet2 and provide count in embedded label in sheet1
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-05-2015, 11:27 AM
  2. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  3. [SOLVED] Summarize data with count ifs/sumifs or similar
    By bertrand82 in forum Excel General
    Replies: 1
    Last Post: 05-21-2012, 06:58 AM
  4. add and count dates and summarize results
    By cathal78 in forum Excel General
    Replies: 9
    Last Post: 02-12-2011, 05:42 PM
  5. Count Unique values and summarize totals
    By MattG in forum Excel General
    Replies: 3
    Last Post: 06-26-2009, 04:59 PM
  6. [SOLVED] COPY LABEL FORM FROM EXCEL TO A LABEL
    By xrayAndi in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-05-2006, 10:25 AM
  7. Count and summarize text fields dcountda/pivot?
    By rispalt@yahoo.se in forum Excel General
    Replies: 0
    Last Post: 11-05-2005, 01:40 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