OPTION IN 'COUNTIF' COMMAND
OPTION IN 'COUNTIF' COMMAND
(OP)
I am not familier with writing of Macros in EXCEL.
I have an Excel spreadsheet in which I have data of different categories identified through different colour fills in the respective cells.
If I have to count the number of cells with a specific category, is there any option in countif command to count the cells with same colour fill?
Thanks for the help.
I have an Excel spreadsheet in which I have data of different categories identified through different colour fills in the respective cells.
If I have to count the number of cells with a specific category, is there any option in countif command to count the cells with same colour fill?
Thanks for the help.





RE: OPTION IN 'COUNTIF' COMMAND
CODE
Application.Volatile
GetColorIndex = R(1, 1).Interior.ColorIndex
End Function
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: OPTION IN 'COUNTIF' COMMAND
------------------------------------------
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail."
Wm. Phelps Eno, ca. 1928
RE: OPTION IN 'COUNTIF' COMMAND
Kudos to ACtrafficengr !
A very elegant and appropriate solution, indeed. Thanks.
RE: OPTION IN 'COUNTIF' COMMAND
The tips were really helpful
Trilinga