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.

=IFERROR(('Sheet1!B2+'Sheet1!B4+'Sheet1!B5+'Sheet1!B6+'Sheet1!B9+'Sheet1!B10+'Sheet1!B12)/('Sheet1!B2+'Sheet1!B4+'Sheet1!B5+'Sheet1!B6+'Sheet1!B9+'Sheet1!B10+'Sheet1!B12+'Sheet1!C2+'Sheet1!C4+'Sheet1!C5+'Sheet1!C6+'Sheet1!C9+'Sheet1!C10+'Sheet1!C12),0%)

 

image.png

1 Reply