+ Reply to Thread
Results 1 to 2 of 2

SUM IF calculation.

  1. #1
    Registered User
    Join Date
    03-14-2017
    Location
    london, england
    MS-Off Ver
    office 2013
    Posts
    73

    SUM IF calculation.

    Hi

    In column C i have a total amount of boxes for each specie per grade. In Column D i have a sum if calculation whcih works by using the code in column B and matching that with it being used in column H.

    Id like to change the formulae so that i can match it by specie in column A and grade in column B.


    Example
    currently A7 = COD, B7 = C1, Id like to change to A7 = COD, B7 = 1

    So F7 Would = cod and H7 = 1

    ID like to change my exsisting sum if in C1 to have 2 criterias rather than a code.
    Attached Files Attached Files

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,242

    Re: SUM IF calculation.

    Please try at D7

    =C7-SUMIFS($I$7:$I$144,$F$7:$F$144,LEFT(LOOKUP("zz",A$7:A7),3)&"*",$H$7:$H$144,B7)

    There is extra space after HAD in F13:F25 , asterisk is added to cover that &"*"
    Attached Files Attached Files

+ 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. Replies: 10
    Last Post: 07-22-2019, 06:27 AM
  2. [SOLVED] VBA to open a workbook with manual calculation and close with automatic calculation
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2019, 12:28 PM
  3. [SOLVED] Calculation of dates and leaving blank cell when calculation sees non-date values
    By Hedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2018, 07:52 AM
  4. Replies: 0
    Last Post: 05-17-2014, 10:18 PM
  5. Replies: 4
    Last Post: 07-23-2013, 07:51 AM
  6. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  7. [SOLVED] Conditional statement calculation based on result of previous calculation.(Need some help)
    By takeprofit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 01:45 AM

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