#INCORRECT ARGUMENT error
Hi (again!)
From other answers I've found here I'm guessing this is a parenthesis issue but I can't work out which ones.
=COUNTIF({Clinical Trials : Accepted Range 1}, >=TODAY(), {Clinical Trials : Accepted Range 2}, HAS(@cell, "Blacktown"))
Trying to sort current contracts (expiry date today or later) by research site
ie: Blacktown research site has 60 currently running trials with us
Hope that makes sense.
Answers
-
Hello @KayH
The COUNTIF (singular) function works with one and only one criteria. The formula above has two sets of criteria. The COUNTIFS (plural) function can work with one to any number of criteria. Try this
=COUNTIFS({Clinical Trials : Accepted Range 1}, >=TODAY(), {Clinical Trials : Accepted Range 2}, HAS(@cell, "Blacktown"))
Does this work for you?
Kelly
-
Hi Kelly... of course, I should of seen that... thank you... although it is now returning a value of 0 which isn't right... I'll have to keep working on it.
Help Article Resources
Categories
Check out the Formula Handbook template!