Re: Compute an Average by category

Why don't you filter that column as well, use custom and not equal to 0,
that will hide zeros
blanks are never included unless you use arrays and this wouldn't be that


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




<glen.e.mettler@xxxxxxxx> wrote in message
news:1143575687.589562.310590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
That will average visible rows but it includes the 0 and empty cells in
the calculation.
How can I get it to ignore 0 and empty cells?

Glen



.

Relevant Pages

  • Re: Sharpening oversampled STFT-based spectrograms
    ... it seems like it's a custom around here to ponder ... The inexperienced here often combine group2 with group3 and group4 as ... Because when we get a spectrogram using ... Group2 concerns bring in zeros. ...
    (comp.dsp)
  • Re: Is Greenspun enough?
    ... >George Neuner wrote: ... I've written several custom allocators from scratch for realtime use ... most I have ever needed to do is preallocate arrays of objects and do ... array memory to be non-pageable]. ...
    (comp.lang.lisp)
  • Re: Display Zeros (0) in blank cells
    ... I should point out that both of my suggestions *change* blanks to ... ignore blanks but treat zeros as values. ... It is possible to quickly convert blanks to cells without any ... display 0 when you hit it. ...
    (microsoft.public.excel.programming)
  • Re: bug in zeros and ones when "logical" class name is used
    ... Trailing string input must be a valid numeric class name. ... name as the last input to the ZEROS function, it must be a valid numeric ... For example, sparse arrays and double-precision ... logicals are not." ...
    (comp.soft-sys.matlab)
  • Re: Error code
    ... adding those 1 column matrix files, ... While combining three arrays with the command in matlab 7, ... with best Regards, ... By filling in zeros in the bottom of the shorter matrixes? ...
    (comp.soft-sys.matlab)