Help with COUNTIFS

Hello.

I am trying to set up a part of my metrics sheet that will count using a COUNTIFS function. I will need the conditions to be Approve and Deny, and I will need them to be able to accept each condition by year. I will attach pictures of what I mean.

So I will cross refrence this sheet using the date column which will be sorted by year (2024,2025,etc). And also the Approve column which either has the option to be Approve or Deny

I want it to end up here in my metrics sheet which I am in the process of making a dashboard. am not sure how I should use a range and criterion to only count the approve and deny for the given year as shown…

Can someone help me with the function for the last part of counting by date please?

Thanks.

Find more posts tagged with

Accepted answers

All comments

Ty Werven

here is the formula I'm using that isn't working…

=COUNTIFS({6AB Range 1}, "Approve", {6AB Range 2}, YEAR(@cell) = $[Column2]@row))

Mark.poole

@Ty Werven

It looks like you got one too many ) at the end of your formula. My test show your formula should work otherwise.

Your Formulas should be

=Countifs({6AB Range 1}, "Approve",{6AB Range 2}, Year(@cell) = $[Column2@row)

=Countifs({6AB Range 1}, "Deny",{6AB Range 2}, Year(@cell) = $[Column2@row)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.