Am having a problem with an average function. Maybe someone can help.
I have a range of cells, A1, B1, C1 with values in them and one cell, D1 with blank.
I want to show an average of, well, blank for the D cell calculation. It should look like this:
23% 33% 44% blank
23% 26% 34% blank
I hope I explained it well.
You better better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Re: Averaging with a blank cell, needs to show blank calculation
Probably you can use the following:
=IF(COUNT(A1:D1);AVERAGE(A1:D1);"")
OR
=IF(COUNT(A1:D1),AVERAGE(A1:D1),"")
FAUSTO CRUZ
Fausto Cruz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks