Want to do an IF/AND but not skilled enough to make it work

=COUNTIFS([Proposed Finished Year]1:[Proposed Finished Year]22, 2022, [Strategic Initiative]1:[Strategic Initiative]22, "Revenue Growth")

COUNTIFS({Sheet - Project Requests Range 2}, Primary35)

Trying to tie the two formulas together to count each initiative (there are 5) in rows and only for 2022.

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Judith

There are two different formulas here, one looking cross-sheet and one looking in-sheet. Can you clarify a little more what you're looking to do?

If you're looking for an overall count, adding together both sheets, then you can use + to do something like this:

=COUNTIFS([Proposed Finished Year]:[Proposed Finished Year], 2022, [Strategic Initiative]:[Strategic Initiative], "Revenue Growth") + COUNTIFS({Proposed Finished Year - Sheet 2}, 2022, {Strategic Initiative - Sheet 2},"Revenue Growth")

If I've misunderstood your set-up, can you explain what this formula is looking at:

COUNTIFS({Sheet - Project Requests Range 2}, Primary35)

Cheers!

Genevieve

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.