CountIf function on combo-box entries
Hi,
Is this combo box entering the data in a spreadsheet range?
If so and that range is A2:A100 you can use the following formula:
=SUMPRODUCT(--ISNUMBER(SEARCH(B1,A$2:A$100)))
in this case you enter Diabeties in cell B1.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Roxy" wrote:
We have a 2 column combo box (Active X) set up that shows a procedure code
along with its text name to help users with data entry.
Example:
725.1 Diabetes
546.2 Heart Disease
Would it be possible to do a count if function on the data so see how many
Diabetes cases? It doesn't look like one could filter this either.
Any ideas? My VBA skills are limited. Thanks!!
|