Can I use Or more than once in a sumifs formula?

Sean Fritz

the formula below sums the time served column for just " SPD minor" for January and does not add zeroes to my dashboard. I would like to combine the time served for SPD Minor, SPD Major and SPD continued.

=IF(SUMIFS({N TS}, { N Intervention}, ="SPD minor", { N Date}, YEAR(@cell) = 2022, { N Date}, MONTH(@cell) = 1, { N TS}, >0) = 0, "", SUMIFS({ N TS}, { N Intervention}, ="SPD minor", { N Date}, YEAR(@cell) = 2022, { N Date}, MONTH(@cell) = 1, { N TS}, >0))

Michael Culley

If I'm understanding correctly, you should just be able to add the different sumifs together.

=sumifs({this},"that",{this2},"that2") + sumifs({other},"thing",{other2},"thing2")