Calculating averages

%3CLINGO-SUB%20id%3D%22lingo-sub-2813117%22%20slang%3D%22en-US%22%3ECalculating%20averages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2813117%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20table%20of%20values%20and%20want%20to%20show%20their%20averages.%26nbsp%3B%20When%20I%20use%20the%20AVERAGE(...)%20function%2C%20it%20gives%20me%20the%20Division%20by%20Zero%20Error.%26nbsp%3B%20What's%20going%20on%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2813117%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a simple table of values and want to show their averages.  When I use the AVERAGE(...) function, it gives me the Division by Zero Error.  What's going on?

1 Reply

@Billingsbp 

The range you provided in the AVERAGE() function most likely does not contain numbers.

Check each cell with ISNUMBER() function.