I am unable apply this formula to the whole column.

Options

=COUNTIFS({Carpenter Sheet 2024 Range 3}, "Installation Ph 2", {Carpenter Sheet 2024 Range 2}, Date@row, {Carpenter Sheet 2024 Range 1}, CONTAINS(@cell, $City1))

$City1 is a cell having two drop down values

Answers