#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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

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

KayH

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.