Excel formula help

[Jagdev Singh]

Hi Experts

I need formula which will calculate on name basis (Column A) how many cells in column B are empty.

Regards,
JD

 

[Deepak]

What's the expected result.

 

[Jagdev Singh]

Hi Deepak

The output should be

Jagdev = 2 (Count of blank in front of my name in columnB)
Ram = 2
Shyam = 2

Regards,
JD

 

[Deepak]

Check this...

=COUNTIFS(A:A,A2,B:B,"")

 

[jayalaxmi]

Hi Experts

I need formula which will calculate on name basis (Column A) how many cells in column B are empty.

Regards,
JD

hey jagdev pls be more precise on the ouput u needed??

calculate what???

Regards
Jaya

 

[Deepak]

Check this...

=COUNTIFS(A:A,A2,B:B,"")

Or this.

 

[jayalaxmi]

Or this.

hey Deepak gud one

 

[Jagdev Singh]

Hi Deepak

Thanks for both the formulas.

Regards,
JD

 

[Deepak]

Hi Deepak

Thanks for both the formulas.

Regards,
JD

Have it did what u are looking for..

 

[Jagdev Singh]

Hi Deepak

Yes, your both the formulas are fitting in my requirement.

Regards,
JD