SUMIFS with 2 criteria coming up zero
This formula keeps returning a zero. I am trying to get it to count two different things in the same column (not sure why they were labeled differently) but when I get the formula plugged in it comes back with zero, when I know that's wrong.
I want it to count up the engineering hours based on the product lead, excluding things that have 2024 listed as a priority.
=SUMIFS([Engineering Hours - Enrich Team]:[Engineering Hours - Enrich Team], [Product Lead]:[Product Lead], "Madeline Hasegawa", [Product Lead]:[Product Lead], "Madeline Hasegawa +1", Priority:Priority, <>"2024")
Help Article Resources
Check out the Formula Handbook template!