I want to be able to count all cells of a particular format in one column given a condition in Microsoft Excel. When I use the CELL("format", [cell]) command, all cells in that column are of format G apart from one which is of type F0. I want to be able to use something like:
COUNTIFS(range, condition, range2, CELL("format")="F0") This however seems to return 0 rather than what it should return, which is 1. Any help would be appreciated! Thanks!