+ Reply to Thread
Results 1 to 2 of 2

Multiplying by quanitity in parenthesis for COUNT result.

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    San Antonio, Texas, USA
    MS-Off Ver
    2016
    Posts
    2

    Multiplying by quanitity in parenthesis for COUNT result.

    Just wanted to know if anyone on here has had any experience with taking a number with the quantity referenced within parenthesis in one cell and have it extend to as many cells as that would apply to in order to then take a count.


    For example:
    cell A1
    1001(4)

    cell A1 cell A2 cell A3 cell A4
    1001 1001 1001 1001


    At the end, I would just need to know how many of each value I have. Any suggestions?

    Thank you very much.
    Attached Images Attached Images
    Last edited by mchapa; 06-22-2016 at 04:31 PM.

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Multiplying by quanitity in parenthesis for COUNT result.

    Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

    If you need to post an image post it in the *.jpg format.

    Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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: 1
    Last Post: 04-10-2016, 11:42 AM
  2. Replies: 0
    Last Post: 03-05-2013, 07:20 AM
  3. Replies: 11
    Last Post: 01-23-2013, 02:04 PM
  4. Replies: 2
    Last Post: 04-12-2012, 02:43 PM
  5. Multiplying then dividing the result of the multiplication
    By cbaker1615 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-08-2010, 04:09 PM
  6. Comparing columns then multiplying result by particular cell
    By raehippychick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2008, 01:39 PM
  7. [SOLVED] want a formula give total quanitity break up frm other sheet
    By Aristotle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2006, 04:10 AM

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