Hi,
I’d like to sum some values in a money cell based on the status in a checkbox cell. Is this possible?
i.e. sum dollar value if checkbox is selected ‘yes’.
Thanks!
Hi,
Yes, you could try SUMIF() formula. If the field value of checkbox is ‘Yes’ when it’s checked, apply this formula SUMIF(field checkbox ,‘Yes’, field dollar ) , details about formulas, please refer to this document.