Results 1 to 5 of 5

Sumif And countif combined function

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    York
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    59

    Sumif And countif combined function

    Hi

    I need to come up with a way to sum the total value (col G o J) where the volume (K to N) is greater than the thresholds in A & B,

    if the threshold isnt met, i need to ignore the value, ie row 7, it will only sum cells H7 & N7

    thresholds values volumes
    From To turnover 13014 PREMIER 3928.75 3623.27 3697.11 3135.27 471 447 454 378
    100 149 13132 PREMIER 765.49 1015.74 899.38 926.16 178 172 175 161
    150 199 13187 CONTRACT 953.88 1141.26 1018.14 855.76 104 110 105 101
    200 249 13582 PREMIER 5765.43 5496.41 6344.16 5971.24 1026 1019 989 1131
    250 299 14134 PREMIER 2284.81 2262.05 2354.17 2129.86 283 287 291 279
    300 399 14348 PREMIER 2609.31 2861.73 2559.94 2564 292 306 268 306

    thanks in advance!!!!
    Adi

    thanks
    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. Countif & sumif combined required to solve answer - please help
    By ACLARKE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2013, 05:13 AM
  2. How do I add a countif, averageif and sumif function
    By susiesc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2013, 12:11 AM
  3. [SOLVED] Countif function combined with conditional formatting
    By molson1973 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2012, 07:13 PM
  4. The SUMIF & COUNTIF Function
    By ugaskidawg in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-07-2008, 09:30 AM
  5. countif function or sumif
    By tipuser in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2007, 12:51 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