sum and count ifs

[flychic]

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>

# flights	date	wing size
2	11/7/17	10,5
7	11/4/17	10,5
2	11/2/17	10,5
1	10/30/17	16
1	10/29/17	9
6	10/29/17	10,5
2	10/28/17	42
3	10/28/17	9
6	10/28/17	10,5

<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>

 

[gvillepa]

Sumif you are totaling numbers in flights column. Countif if not summing # flights. Here's sumif:

Book1
	A	B	C
1	Flights	Date	Wing Size
2	2.00	11/7/2017	10,5
3	7.00	11/4/2017	10,5
4	2.00	11/2/2017	10,5
5	1.00	10/30/2017	16
6	1.00	10/29/2017	9
7	6.00	10/29/2017	10,5
8	2.00	10/28/2017	42
9	3.00	10/28/2017	9
10	6.00	10/28/2017	10,5
11
12	23
Sheet1

Cell Formulas
Range	Formula
A12	=SUMIF(C2:C10,"10,5",A2:A10)

 

[flychic]

@gvillepa - that's the one, thank you so much!!

Sumif you are totaling numbers in flights column. Countif if not summing # flights. Here's sumif:

	A	B	C
1	Flights	Date	Wing Size
2	2.00	11/7/2017	10,5
3	7.00	11/4/2017	10,5
4	2.00	11/2/2017	10,5
5	1.00	10/30/2017	16
6	1.00	10/29/2017	9
7	6.00	10/29/2017	10,5
8	2.00	10/28/2017	42
9	3.00	10/28/2017	9
10	6.00	10/28/2017	10,5
11
12	23

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula A12 =SUMIF(C2:C10,"10,5",A2:A10) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[flychic]

One more scenario - if Column D states the name of a wing, how do I calculate the sum of that type of wing? For example, if I want to know how man flights are on the 21 Hook, how do I determine the difference between the 21 Goose?


<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

	A	B	C	D
1	Flights	Date	Wing Size	Name
2	2	11/7/2017	10,5	Goose
3	7	11/4/2017	10,5	Goose
4	2	11/2/2017	10,5	Goose
5	1	10/30/2017	21	Goose
6	1	10/29/2017	21	Hook
7	6	10/29/2017	10,5	Goose
8	2	10/28/2017	42	Twin
9	3	10/28/2017	21	Hook
10	6	10/28/2017	21	Goose
11
12	23

<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>