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?
Thanks,
Nicole
Best Answer

Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers

Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!