Results 1 to 8 of 8

Sum with 2 conditions

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2016
    Location
    sWITZERLAND
    MS-Off Ver
    2013
    Posts
    14

    Sum with 2 conditions

    Hi All

    I am trying to solve one function that keeps me awake at night.

    I need to sum data under two conditions

    if in column A data is not marked green & in column B in respective row chosen txt is shown ( different sites, paris, madrid etc) then sum respective positions in column A
    I managed to get close with following function however if there is more then 1 marked green then it breaks the sumup
    =SUMIFS($A5:$A369 ; $B5:$B369 ; B195(cell with the txt) ; $B5:B369 ; SummeWennFarbe(A5:$A369;$B$39(cell with green colour)))
    Last edited by KaBom; 09-01-2016 at 05:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  2. Replies: 6
    Last Post: 04-30-2015, 09:10 AM
  3. Replies: 1
    Last Post: 03-26-2014, 02:14 PM
  4. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  5. [SOLVED] Text results with two conditions (lookup with two conditions)
    By Davzx in forum Excel General
    Replies: 8
    Last Post: 05-25-2012, 03:08 AM
  6. convert the if conditions to OR conditions
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-09-2011, 06:41 PM
  7. How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04:06 PM

Tags for this Thread

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