Please help mo to solve my problem in excel

[Closed]
Report
-
 Irfan Khan -
Iwant to get the total of this
column B-----C
ACFT CHECK TVP
B777 A
B747 B
B777 A
B777 A
B777 A
B747 B
B747 A
i want to get the total of B777 that have = A the reult is 5..
what is the formula to get this....

1 reply

you can use SUMIFS function to solve ur problem