sumif column C and Column D equal set criteria

[flychic]

I'd like to know if a cell equals a certain criteria, what the total number is of said criteria. For example, if column A is number of flights, column B is the date, column C is the size of wing flown, and column D is the name of the wing - I want to know if the size of wing flown is "21" and the name of the wing is "Goose", how many flights were completed (total). What formula will add up column A if C = "21" and D = "Goose"



[TABLE="class: cms_table, width: 0"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Flights[/TD]
[TD]Date[/TD]
[TD="align: center"]Wing Size[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]11/7/2017[/TD]
[TD="align: center"]10,5[/TD]
[TD]Goose[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11/4/2017[/TD]
[TD="align: center"]10,5[/TD]
[TD]Goose[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]11/2/2017[/TD]
[TD="align: center"]10,5[/TD]
[TD]Goose[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10/30/2017[/TD]
[TD="align: center"]21[/TD]
[TD]Goose[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10/29/2017[/TD]
[TD="align: center"]21[/TD]
[TD]Hook[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10/29/2017[/TD]
[TD="align: center"]10,5[/TD]
[TD]Goose[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10/28/2017[/TD]
[TD="align: center"]42[/TD]
[TD]Twin[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10/28/2017[/TD]
[TD="align: center"]21[/TD]
[TD]Hook[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10/28/2017[/TD]
[TD="align: center"]21[/TD]
[TD]Goose[/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Use this sumifs formula

=SUMIFS(A2:A10,C2:C10,21,D2:D10,"Goose")

 

[flychic]

awesome, thank you so much!