Averaging Values with N/A's

Hey everyone,

So I have a quick question. I created this table that's calculating averages of averages.

Essentially, I am taking a number (like 5) in one column and multiplying by an average I calculating somewhere else in the sheet (say 2.67)

Now, there are many rows that have numbers like this ex: 5 and 2.67, 32 and 5.43, 70 and 4.02, so on so forth.

The issue is, some of the rows have N/A's in the second column because there is no data to calculate an average.

Is there a way to disclude those N/A's from my formula where I'm essentially taking an average of the average values? Here's the equation...sorry it's a bit long. Let me know if there's a better way to write that as well.

=((E260*D260)+(E261*D261)+(E262*D262)+(E263*D263)+(E264*D264)+(E265*D265)+(E266*D266)+(E267*D267)+(E268*D268)+(E269*D269)+(E270*D270)+(E271*D271)+(E272*D272)+(E273*D273)+(E274*D274)+(E275*D275))/D277

Hopefully this works...

Hey Glenn!

yes, that's exactly what I needed. Thank you for taking a look at the sheet.

Sorry, I deleted it! I thought I didn't post it correctly, but it turns out I did.

First post and was just trying figure out the ropes.

Appreciate the help!