Calculating how many time a value shows up in a column in a certain month
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?
Help Article Resources
Check out the Formula Handbook template!