SUMIFS - If value is equal to 0 or greater than 11

[Sineadd]

Hi

I am using the following formula to sum if the value in cells B;2:B44 is equal to 0 or greater than or equal to 11 but it just keeps returning "0 "

=SUMIFS(A2:A44, B2:B44,"=0", B2:B44,">=11")/A45


Anyone point out where I am going wrong - I am using it for other criteria and that's working fine, I have also tried putting in <1 and >=11 but that does not work either


Thanks

 

[Michael M]

Is this what you wanted

=SUMIFS(A2:A44,B2:B44,{"=0",">=11"})/A45

 

[jasonb75]

Try

=SUMPRODUCT(SUMIFS(A2:A44, B2:B44,{0,">=11"}))/A45

Sumifs, or any similar function will not work if you use the same range with multiple criteria that can not be met at the same time. For a result to be provided, all criteria must be met. A cell can not be both =0 and >=11 at the same time.

 

[Sineadd]

Try

=SUMPRODUCT(SUMIFS(A2:A44, B2:B44,{0,">=11"}))/A45

Sumifs, or any similar function will not work if you use the same range with multiple criteria that can not be met at the same time. For a result to be provided, all criteria must be met. A cell can not be both =0 and >=11 at the same time.

Thank you