Conditional 'Countifs' for merged cells..??

Hello,

I have to create some data sheet in which one column has merged cells.

I wanna use "countifs" function to extract data.

Data has two attributes - 1) Plan and 2) Status

For any merged cell, if Plan date is mentioned and status is not "Done", it should count that cell.

Please refer attached file for clarification.

Thank you...!!

Conditional.xlsx

Put this formula in cell q3 and drag down
=COUNTIFS($A$1:$A$11,P3,$C$1:$C$11,">"&0,$C$2:$C$12,"")

In BA you have given expected result is 1 i thing that should be two.

Regards,
Suhas

Put this formula in cell q3 and drag down
=COUNTIFS($A$1:$A$11,P3,$C$1:$C$11,">"&0,$C$2:$C$12,"")

In BA you have given expected result is 1 i thing that should be two.

Regards,
Suhas

Put this formula in cell q3 and drag down
=COUNTIFS($A$1:$A$11,P3,$C$1:$C$11,">"&0,$C$2:$C$12,"")

In BA you have given expected result is 1 i thing that should be two as you mentioned date is there and next cell blank.

Regards,
Suhas

Thank u all. Both the solutions worked for me.

Yes Mr Suhas, Ii should be "2" only. Its a mistake.