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
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
=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
Perhaps some sample data with expected results would be helpful...
I will upload the document tomorrow internet connection is giving problems
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks