Countif with multiple criteria

I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1").

I'm trying =countifs(range1, "Approved") +countif(range 2, ???)

The question marks if where I am having issues. The column is formatting as a date not text/number so that may be the issue. I tried =countifs(range1, "Approved") +countif(range 2, NOT(ISBLANK(@cell)) and it returned a wrong number.

Any suggestions? I'm getting really frustrated.

Find more posts tagged with

Formulas

Accepted answers

All comments

Nic Larsen

Try this format. Just update my formula for your range names.

=COUNTIFS(date:date, NOT(ISBLANK(@cell)), [range1]:[range1], ="Approved")

Metric Momma

What am I doing wrong? I'm trying to count how many projects each team member is working on but I need the status of their project assignments to be In Process. I'm using this for a metrics table so I'm referencing a different report for source data.

This one is IMPARSEABLE

=IF({Product Bible Project Status}, "In Process"), COUNTIF([Primary Column]@row))

This one is INCORRECT ARGUMENT

=COUNTIF([Primary Column]@row, {Product Bible Project Status}, "In Process")

This one returns 0 and that's not correct

=COUNTIF([Primary Column]@row, {Product Bible Project Status} = "In Process")

Paul Newcome

@Metric Momma What are you wanting to compare to the [Primary Column]@row? Proper syntax is going to be

=COUNTIFS({Range 1}, Criteria 1, {Range 2}, Criteria 2)

TinaM

I am working on a countif statement across multiple workspaces using: =COUNTIFS([{Communication Status}, "Complete", {Milestone}, "30 Days post Merger Date"], [{Finance Status}, "Complete', {Finance Milestone}, "30 Days post Merger Date"]) but I keep getting #UNPARSEABLE. Am I using the incorrect formula? I have tried SUMIFS as well with the same result.

Thanks for the look and hopefully assistance

Paul Newcome

Try removing all of your [square brackets]. They are not needed in your formula.

TDM

Hi all so now i am the one stuck after looking all over the place.

i have 2 COUNTIF that work fine on their own, but i want to join them together. making was there an issue this year.

=COUNTIF([Was there an issue during the event]:[Was there an issue during the event], 1) + ""

=COUNTIF([Event date UTC]:[Event date UTC], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

if you allso know how to do a this quater instead of year that would be amazing

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.