Help with SUMIFS and value hierarchy

[drizzzle_]

I am trying to use SUMIFS for my project, which works until a certain level. The values for my criteria are: Q1 2022, Q2 2022, Q3 2022, ... until Q12 2022. I think Excel automatically assumes that P10 2022 is next to P1 2022 because, for example, when I use ">=P10 2022" in my sumifs formula, it doesn't include those with the P1 2022 value. How can I go about this? Can this be fixed?

 

[drizzzle_]

I am trying to use SUMIFS for my project, which works until a certain level. The values for my criteria are: Q1 2022, Q2 2022, Q3 2022, ... until Q12 2022. I think Excel automatically assumes that P10 2022 is next to P1 2022 because, for example, when I use ">=P10 2022" in my sumifs formula, it doesn't include those with the P1 2022 value. How can I go about this? Can this be fixed?

I'm sorry, assume that the values are "Q# 2022". I got confused and used "P#" in some.