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