Results 1 to 5 of 5

Multiple conditions IF, percentage calculation on a range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2020
    Location
    Switzerland
    MS-Off Ver
    2016
    Posts
    4

    Multiple conditions IF, percentage calculation on a range of cells

    Dear community,

    It has been hours now since I am trying to solve an issue with a calculation. As you may see on the attached picture.
    I am trying to calculate a percentage based on multiple conditions on ranges of cells.

    I would like to calculate as follows: If the "item category" is [Fruit] and if there is a number in "Organic surface", then I would like to calculation the % of this specific fruit weight out of the sum of Fruit weight. (in this case 2 tons / (2 + 1 + 0.5) tons).
    I would like this formula to be valid for the whole ranges (2 : 12) for all columns.

    TEST_Excel.png

    I hope I am clear enough,
    Many many thanks for your support,
    DW
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting percentage of month with multiple conditions
    By MrExcelsior in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2019, 02:03 PM
  2. Multiple percentage calculation through VBA
    By brajesh.sharma87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2018, 09:34 AM
  3. If / Then statement with multiple conditions for range of cells
    By micina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2017, 05:54 PM
  4. True/False for Multiple conditions and formats in a range of cells
    By Vatoemperor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2015, 03:51 PM
  5. [SOLVED] Percentage calculation based on multiple date criteria
    By odahilys in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-26-2015, 10:10 AM
  6. Replies: 1
    Last Post: 01-13-2013, 08:39 PM
  7. Median calculation on multi-range with conditions
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2011, 03:32 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