Sum cells in a table when a column meets multiple conditions

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


Refer to Conditional Summing


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




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