Results 1 to 19 of 19

filtering numbers?

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2010
    Location
    suffolk
    MS-Off Ver
    Excel 2007
    Posts
    29

    filtering numbers?

    Hello
    I've been trying to find a formula that I need but am unable to. Can anyone help?

    There are two columns A & B. In A there is a sum of positive & negative numbers. B contains an average of positive numbers, present value 20. In a 3rd column I need a formula based on column A that includes all numbers that are the average result of colomn B or lower but excludes ones higher than the column B result.

    The manually worked out answer should be 16.60.

    Any ideas.

    Alex G
    Last edited by Alex G; 04-04-2010 at 03:48 PM.

Thread Information

Users Browsing this Thread

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

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