Calculate percentage from another sheet

Copper Contributor

Hi, I have this table in sheet 1, I want to calculate the sum of yes/sum of (yes+ no) of the specific cells(A1, A3, A4, B1, B4, C1, C3) cells in "sheet 2", How to write a simple formula, not a big one?

currently, I am using this formula.




1 Reply