Calculating how many time a value shows up in a column in a certain month

Felkernic

I have tried the formulas on here suggested to figure out how many times the word transfusion showed up in the Code column on a Date column February. I keep getting unparsable or invalid ref# . I even tried the IFERROR in case I had blanks but no go.

I was able to figure out how many times the word transfusion showed up in the Code column in the Department of MCWH. See my data below.

=COUNTIFS(Code1:Code20, "Transfusion", Department1:Department20, "MCWH")

I am very confused about what the Month(@cell) thing is?

Thanks,

Nicole

Darren Mullen

https://youtu.be/KchiWBgsv4A

@Felkernic

Nicole,

See if my video explaining the @cell operator helps:

Darren Mullen

https://youtu.be/KchiWBgsv4A

@Felkernic

Nicole,

See if my video explaining the @cell operator helps: