+ Reply to Thread
Results 1 to 5 of 5

sum with 2 criteria

  1. 08-11-2014, 11:13 PM #1
    pedjvak is offline
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    sum with 2 criteria

    Hi every body
    could you please help me on attachment file
    I show you on my file what I want
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-11-2014, 11:29 PM #2
    lancer102rus is offline
    Forum Contributor lancer102rus's Avatar
    Join Date
    04-02-2014
    Location
    Ufa
    MS-Off Ver
    Excel 2010, 2013
    Posts
    252

    Re: sum with 2 criteria

    SUMIFS formula
    SUMIFS.xlsx
    Reply With QuoteRegister To Reply
  3. 08-11-2014, 11:32 PM #3
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: sum with 2 criteria

    Try this.....

    In I5
    Please Login or Register  to view this content.
    and then copy across and down.

    Or

    In I5
    Please Login or Register  to view this content.
    and then copy across and down.

    Is this what you are trying to achieve?
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 08-11-2014, 11:34 PM #4
    BS Singh is offline
    Forum Contributor
    Join Date
    08-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: sum with 2 criteria

    Hi Pedjvak,

    This can be done..however may I ask you to show your desired output by filling some result cells manually.

    Regards,
    Reply With QuoteRegister To Reply
  5. 08-11-2014, 11:37 PM #5
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: sum with 2 criteria

    See attached
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  2. [SOLVED] If 2 criteria are met, total 1 matching range of criteria & paste to columns on 2nd sheet
    By Terri H in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  3. Macro to search for a criteria and begin copying data into a new sheet based on criteria
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  4. [SOLVED] create drop down box to select multiple criteria and link macro to each criteria
    By anand_erin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-03-2012, 06:35 PM
  5. Excel 2007 : Adding Values In Columns with Multiple Criteria Where Column Head is One Of Criteria
    By ctac in forum Excel General
    Replies: 2
    Last Post: 10-05-2011, 12:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1