Calculate average percentage for specific selected cells

1. Calculate average percentage for specific selected cells

Hello everyone

I need to calcualte a percentage average for specefic selected cells which formula should I use?

Thanks

Megan  Register To Reply

2. Re: Calculate average percentage for specific selected cells

=AVERAGE(cell1,cell2,cell3,so on and so forth)  Register To Reply

3. Re: Calculate average percentage for specific selected cells Originally Posted by BadlySpelledBuoy =AVERAGE(cell1,cell2,cell3,so on and so forth)
The problem is I have a spreadsheet with questions the questions are answered by a 0 or 1 or n/a if u type n/a then it must exlude that from the percentage I managed to get a formula with average if but I need the formula to work out if i select a1 skip a2 then calculate a3 and a4  Register To Reply

4. Re: Calculate average percentage for specific selected cells

Perhaps some sample data with expected results would be helpful...  Register To Reply

5. Re: Calculate average percentage for specific selected cells

I will upload the document tomorrow internet connection is giving problems  Register To Reply