# Google Sheets: Average but without using range

1. ## Google Sheets: Average but without using range

Hello! Just want to ask if there is an easy way for me to find the average but not using range since the values are placed in different cells?

Here the cells and the formula that I'm using to get the average (J28+O28+T28+Y28+AD28+AI28+AN28+AS28+AX28)/8

It is working, yes. But the problem is that there is a cell that the value may be empty. For example, all of it has a value except for AS28 & AX28, so the denominator should be 6 and not 8.

Is there a way for me to easily do this? Thanks!

2. ## Re: Google Sheets: Average but without using range

Try each of the following

Formula:
`Please Login or Register  to view this content.`

Formula:
`Please Login or Register  to view this content.`

Formula:
`Please Login or Register  to view this content.`

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