Please help mo to solve my problem in excel

Closed
sheldon201987 - Jan 20, 2010 at 01:56 AM
 Irfan Khan - Jan 27, 2010 at 09:11 AM
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
0