# Calculate average percentage for specific selected cells

1. ## Calculate average percentage for specific selected cells

Hello everyone
Please help

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

Will really appreciate your help

Thanks

Megan

2. ## Re: Calculate average percentage for specific selected cells

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

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

4. ## Re: Calculate average percentage for specific selected cells

Perhaps some sample data with expected results would be helpful...

5. ## Re: Calculate average percentage for specific selected cells

I will upload the document tomorrow internet connection is giving problems

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1