none
How to use Excel SUMIF or SUMIFS to get the rows filtered out based on and conditions of two column values. RRS feed

  • Question

  • Hi,

    I am very new to the Excel calculations.

    I have to select the sum of column C where Column A = "Value1" and Column B = "Value2"

    Is this possible using Sum if or do I need to do something else.

    The formula which I expect is for,

    Select the total no. of tickets high priority assigned to a particular resource.

    The Excel sheet will be like this

    ColumnA ColumnB ColumnC

    (Names) (Tickets Detail)           (Priority)

    Mathi Ticket1 High

    Mathi Ticket2 Low

    Mathi Ticket3 Medium

    Mathi Ticket4 High

    Vicky Ticket201 High

    Vicky Ticket202 Low

    For the above table when I write a formula to get the no. of tickets which are of high priority assigned to Mathi, Ishould get 2.

    In SQL it is

    SELECT COUNT(Ticket Detail) FROM TABLE WHERE Name = "Mathi" and Priority = "High"

    Please help me to do the same in Excel also.

    Thanks & Regards,

    Mathi. 


    With Regards, Mathi.

    Monday, August 17, 2015 2:53 PM

Answers

  • I have to select the sum of column C where Column A = "Value1" and Column B = "Value2"

    If the formula is on the same sheet:

    =SUMIFS(C:C, A:A, "Value1",B:B,"Value2")

    If the formula is on another sheet:

    =SUMIFS('Sheet with Data'!C:C,'Sheet with Data'!A:A, "Value1",'Sheet with Data'!B:B,"Value2")

    If you actually want a count, then use

    =COUNTIFS('Sheet with Data'!A:A, "Value1",'Sheet with Data'!B:B,"Value2")



    Monday, August 17, 2015 5:16 PM