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!

  • This is better suited for stack exchange. This site is about open data. – ako Jun 16 at 17:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.