Results 1 to 7 of 7

Formulas for cumulative value and cumulative %

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Formulas for cumulative value and cumulative %

    How do I find the following using excel formulas:
    What is the total number of items that are A
    What is the total number of items that are B
    What is the total number of items that are C


    What is the cumulative value of the A items
    What is the cumulative value of the B items
    What is the cumulative value of the C items
    What is the cumulative % in units of the A items
    What is the cumulative % in units of the A and B items


    Now for the total numbers I'm using the =COUNTA function since I only want to count the non-empty cells. I'm stuck on the other questions.

    Thank you for taking the time to look at this.
    Attached Files Attached Files
    Last edited by Brotein; 10-27-2013 at 07:31 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help for IF Function to solve my excel problems
    By G_A_S in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2013, 02:48 AM
  2. Hear to learn VBA mysteries and solve some problems
    By Denison in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-30-2013, 05:51 AM
  3. Replies: 3
    Last Post: 09-09-2012, 10:45 AM
  4. 2 problems to solve - Automatically generated template
    By Maraug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2012, 10:46 AM
  5. solve Sorting problems...
    By Gunnett in forum Excel General
    Replies: 2
    Last Post: 06-28-2007, 03:17 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