Calculate percentage from another sheet

Question

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%)

riny_van_eekelen · Answer

Emmarky&nbsp;Similar to your other question here:https://techcommunity.microsoft.com/t5/excel/formula-to-calculate-percentage/m-p/3916868&nbsp;

Forum Discussion

Calculate percentage from another sheet

Share

Resources