I have 2 columns in spreadsheet as mentioned below:
Column A Column B
Closed Master
Open Slave
Error Master
Hold Master
Reopen Slave
I need to Count all "Closed", "Open" & "Hold" status from Column A and corresponding "Master" status from Column B so that the output of that formula will be "2" as per the above example.
Thanks Guys!!!!
Column A Column B
Closed Master
Open Slave
Error Master
Hold Master
Reopen Slave
I need to Count all "Closed", "Open" & "Hold" status from Column A and corresponding "Master" status from Column B so that the output of that formula will be "2" as per the above example.
Thanks Guys!!!!