COUNTIF with a certain word in a week

Hi All,

A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm.

I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would then be reset when the new working week begins

I have the Count formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

I just need to include the Working Week range to the formaula .

Thankyou

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

NickJonesLG

So need to add something to this formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

which only searches for any "Aberdeen"s that were this working working week and then resets when the new working week begins ( Friday 00:00am )

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.