Multi-step formula help needed

Dina Elmore

What formula could I use to count how many GWS divisions are in progress during the year 2022? This is the formula I have but it is not working. Thanks in advance for the help. Dina

=SUMIF({Helix Migration Plan Range 3}, 2022, (SUMIF({{Helix Migration Plan Range 5} ,"In Progress",{Helix Migration Plan Range 4}})))

Paul McGuinness

Hi @Dina Elmore

This should work, you may need to amend as this formula is written within the sheet. so not referencing the ranges etc.

=SUMIFS([GWS Divisions]:[GWS Divisions], [Completion status]:[Completion status], "In Progress", [Planned completion year]:[Planned completion year], "2022")

Hope it helps

Thanks

Paul