LinkBack URL
About LinkBacks
you can count all minus those that you counted:
=COUNTA(F$3:F$201)-COUNTIF(F$3:F$201, "Red")- etc
or, even better to refer to those cells where you already sum it (from your example above):
=COUNTA(F$3:F$201)-B2
you can count all minus those that you counted:
=COUNTA(F$3:F$201)-COUNTIF(F$3:F$201, "Red")- etc
or, even better to refer to those cells where you already sum it (from your example above):
=COUNTA(F$3:F$201)-B2
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks