# Averaging with a blank cell, needs to show blank calculation

1. ## Averaging with a blank cell, needs to show blank calculation

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.

2. ## Re: Averaging with a blank cell, needs to show blank calculation

You better better help on your question if you add a small excel file, without confidential information.

3. ## 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

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