Ok i have a row of numbers in cells A1 to A12 with a total A13 i know to get the average here would just be A13/12 but what i need is the formula to work with blank cells aswell.
So if the numbers are in cells A1 to A11 and A12 is blank I need A13 to show a total divided by 11 as the 12 cell is blank
example:- A1 = 100 giving me answer in A13 as 100 (the average of the only inputed cell)
A1 = 100, A2 = 150 giving me the answer in A13 as 125 (the average of the 2 cells)
and so on
Last edited by ukphoenix; 04-25-2012 at 05:05 AM.
Hi
Why don't you use Average?? Or am i missing something??
=AVERAGE(A1:A12)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Damn how stupid do i feel. what if all cells are empty (for now) result shows #DIV/0!, how do i stop this showing
=iferror(AVERAGE(A1:A12),"") for higher ver of excel
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Or this, for earlier versions, like mine...
=IF(ISERROR(AVERAGE(A1:A12)),"",AVERAGE(A1:A12))
Edit: No one is stupid. Pls, don't feel in this way.
Last edited by Fotis1991; 04-25-2012 at 04:45 AM. Reason: Edit.
Thanx guys, I should know these basic formulas but today just seems to be a brain freeze day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks