Sum cells that meet multiple conditions

{=SUM ( (cellrange > 0) * (cellrange < 20) ) }


Refer to Conditional Summing


SUMIF( criteria_range, "text1", values_range) + SUMIF(criteria_range, "text2", values_range)




© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top