Hi, 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, and column C is the size of wing flown - I want to know if the size of wing flown is "10,5"; how many flights were completed (total). What formula will add up column A if C = "10,5"
A B C
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]# flights[/TD]
[TD]date[/TD]
[TD="align: center"]wing size[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]11/7/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]11/4/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]11/2/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10/30/17[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10/29/17[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10/29/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]42[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
</tbody>[/TABLE]
A B C
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]# flights[/TD]
[TD]date[/TD]
[TD="align: center"]wing size[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]11/7/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]11/4/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]11/2/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10/30/17[/TD]
[TD="align: center"]16[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10/29/17[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10/29/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]42[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]10/28/17[/TD]
[TD="align: center"]10,5[/TD]
[/TR]
</tbody>[/TABLE]