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

• ### 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"

Thanks & Regards,

Mathi.

With Regards, Mathi.

Monday, August 17, 2015 2:53 PM

• 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