+ Reply to Thread
Results 1 to 2 of 2

Calculating sum of values that are over a specified value

  1. #1
    Registered User
    Join Date
    11-22-2014
    Location
    Brisbane
    MS-Off Ver
    2011 for mac
    Posts
    13

    Calculating sum of values that are over a specified value

    I am unsure of what code I need for my function to count all values over 89%. The current script only returns a 0 or a 1 and it needs to return a number based on how many cells (up to 5) are over 95%.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Calculating sum of values that are over a specified value

    You'll have to add them up.
    E.g.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

+ 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. [SOLVED] Calculating values between start and finish values
    By coreytroy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2013, 07:33 PM
  2. Replies: 4
    Last Post: 01-03-2012, 06:05 PM
  3. Calculating values based on other values
    By shippers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2010, 01:11 PM
  4. [SOLVED] Pbl calculating US$ values
    By Joseph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2005, 04:05 AM
  5. Pbl calculating US$ values
    By Joseph in forum Excel General
    Replies: 1
    Last Post: 07-13-2005, 12:05 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