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

Judith

=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.

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