Count No fo Months

[Sajjad]

DearAll

Is any body help me to calculate No of Months in at table of a specific Person

For Example
Column A Column B Column C
Employee Name Sales Month
A 25 1
B 15 1
A 15 2
A 35 3
B 10 2

In Above Columne I have to calculate No of Months of Mr. A

Kindly advise me right formula

Thanks!!!!

 

[Bob Phillips]

=SUMIF(A:A,"A",C:C)

 

[Shane Devenshire]

Hi,

And if you decide you want to sum the sales for A you would use the formula:

=SUMIF(A2:A10,"A",B2:B10)

If this helps, please click the Yes button,

Cheers,
Shane Devenshire