Jun 10 2020 12:53 AM
This is not working:
1) =SUMIF(B6:B15;"AND(>=50;<=75)")
2) =COUNTIF(B6:B15;"AND(>=50;<=75)").
Believe, problem is somewhere in "AND".
Please help.
Jun 10 2020 01:27 AM
@noname385
That's like
=SUMIFS(B6:B15;B6:B15;">=50";B6:B15;"<=75")