Sheet Reference Formula for Last Week?

I have a source sheet set up that has three columns: State, Delivery Date and =WEEKNUMBER from the Delivery Date formula.

I have a metric sheet set up where I want to use a =COUNTIF formula to calculate rows from the source sheet with deliveries by state, and I want it to count by delivery date from the previous week (not previous 7 days).

I have this formula, but of course it's showing INCORRECT ARGUMENT:

=COUNTIF({2024 State}, State@row, {2024 Week}, WEEKNUMBER(@cell) = (WEEKNUMBER(TODAY()) - 1))

What am I doing wrong?

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

DKazatsky2

Hi @amy_ilearning,

For multiple criteria, you need to use "COUNTIFS", other than that, your syntax looks correct. Try changing to "COUNTIFS" and see if that works.

Hope that helps,

Dave

Razetto

@amy_ilearning Have you tried testing it out by referencing the delivery date instead of the week number column?

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.