Averaging columns

G

GarrettSocling

I tried Average, but it won't pass over the broken references either.
Since I have these columns present with no data, I have a divide b
zero error...I need the average to just ignore those columns.

I am a n00b when it comes to Excel, so forgive me if I am overlookin
something simple...

Thanks,
Garret
 
F

Frank Kabel

Hi
you may change your formulas which create the #DIV error. post your
used formulas which create an error
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A useful AVERAGE calculation without using the built-in AVERAGE function 3
Two columns followed by single page-width column on same page 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Ever changing averages, depending on date. 2
Average Function 3
Average time 1
Averaging two ranges on the same column (excluding zeros) 2

Top