I am looking to create a formula to identify values (counts and sums), using a Greater than, Less than scenario.
Example: =SUMIF(COMPANY!Z:Z,">0.0%","<50.0%",COMPANY!M:M) is what I am trying to accomplish, but I know that formula is wrong.
How can I make this work properly?