Calculate The Percentage Of Yes And No From Multiple Sheets

[jkundi]

Hi everyone,

I'm currently using the formula below to count the number of 'Yes' in numerous cells and then show value as a percentage.

=COUNTIF(G1:G10,"Yes")/COUNTA(G1:G10)

And there following formula to show data from another sheet.

=COUNTIF('Sheet 2'!G1:G10,"Ready for QA")/COUNTA('Sheet 2'!G1:G10)

However I'd like to also count cells from multiple sheet too, is this possible with COUNTIF and where would I make the amends to this formula?

Thankyou

Jas

 

[CyrusTheVirus]

What do you mean 'count cells from multiple sheets too'? Can you provide an example? Best to show your starting point (full example) and your expected results that way it gives users the complete picture and allows them to provide an accurate solution. Welcome to the forums!