Looking for a sumif formula with a > and < variable

[DPChristman]

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?

 

[Marcelo Branco]

Maybe SUMIFS

Something like
=SUMIFS(COMPANY!M:M,COMPANY!Z:Z,">0.0%",COMPANY!Z:Z,"<50.0%")

M.

 

[DPChristman]

Perfect. Thanks. Kicking myself, because I have been using =SUMIFS on everything lately, and it never even occurred to me.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.