Excluding zeros in functions

  • Thread starter Thread starter daniel
  • Start date Start date
D

daniel

I have a spreadsheet with a few arrays in each of which there are a few
zeros. I have used a number fuctions (median stdev, var, average etc)
and now realize that I should have excluded the zeros. Is there any
quick way to do this?
Thanks
Daniel
 
Daniel,

Test the range for zeroes within the function, like so

=AVERAGE(IF(A1:A5<>0,A1:A5))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Lowest number excluding zero 2
Subtotal Average excluding zero 9
Averaging non consecutive cells excluding zero's 4
Replace zero values with blank 3
Calculating STDEV for non zeroes 1
Calc RSQ and exclude zeros 3
Zero Upload Speed 6
Displaying zeros in cells 2

Back
Top