looking for help on a formula

Jared123456789

Currently making many sheets to track data per week the formula I am currently using is

=SUMIFS({SIM Resolves}, {Name}, "Alex", {Week Number}, "2")

Is there a way to change the formula to increase by 1 week number automatically or do I have to do it manually?

Find more posts tagged with

Accepted answers

All comments

dojones

Post a snip of the sheet and sample of how you want the data to look. Are you trying to increase the week number in rows or columns?

Jared123456789

Jared123456789

you can see the formula increases by one number is there a way to do that automatically or do I have to do them manually?

Melissa Yamada

Hello @Jared123456789

Try:

=SUMIFS({SIM Resolves}, {Name}, "Alex", {Week Number}, [Week Number]@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.