Forum Discussion

Healthfreo's avatar
Healthfreo
Copper Contributor
Jan 04, 2022
Solved

COUNTING

Hi, I've compiled a spreadsheet (PC, 365) for staff rostering with a dropdown list allowing selection of various shifts, the example shows as DP for MON. Using VBA code for multiple selections in a ...
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Jan 04, 2022

    Healthfreo 

    Try

     

    =COUNTIF(range, "DP*")

     

    and

     

    =COUNTIF(range, "*OC/G")

HansVogelaar's avatar
HansVogelaar
MVP
Jan 04, 2022

Healthfreo 

Try

 

=COUNTIF(range, "DP*")

 

and

 

=COUNTIF(range, "*OC/G")

Resources