Counting the number of occurrences that meet my criteria

Hello,

I need to count the number of approvals received on the created date, on the day after the created date and on anything after that. Here's my formula that's not working:

=COUNTIFS({VP of Sales Status Approval}, "approved", {Created Date}, ={VP of Sales Status Date})

Any help will be much appreciated. Thanks!

Find more posts tagged with

Accepted answers

All comments

Mike TV

@BFuller

Does it work if you put an = in front of "approved"?

BFuller

Hi @Mike TV . Thanks for the response. It works with out an = in front of "approved". When I do the formula just: =COUNTIFS({VP of Sales Status Approval}, "approved", I get all the responses. What I need to do is count how many of those approvals happen same day, the following day and any day after that. I hope that makes sense. :)

Mike TV

@BFuller

Then I believe you can thread in an OR function with the different criteria you want counted. Probably also use @cell within the OR statement for where it should look at.

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.