How to omit blank cells when calculating weighted averages

  • Thread starter Thread starter Suzy
  • Start date Start date
Assuming the numbers are all positive:

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
 
You must log in or register to reply here.

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

Omit empty cells? 0
How do I calculate a weighted average and exclude the empthy cells 2
Calculating weighted average of Percent Change 0
Average not including Zeros/Blanks 8
Weighted Average - Copy Function 7
Averaging blank or cells with Zeros in them. 4
Average formula where blank cells are counted as zeros 4
Omitting blank cells until filled in? 3

Back
Top