Excel VBA code to Average Non Zeros for Multiple Ranges

**theclockmaker** · 03-11-2020, 01:00 PM

I created this VBA code to average one or more ranges of nonzero numbers.

Some example uses would be:

=avgNonZeros(B2:B10,C2:C10,E2:E10)
=avgNonZeros(Q22,R22,U22:Z22)
=avgNonZeros(B2:B10,C10,E10)
=avgNonZeros(B2:B10)

Please Login or Register  to view this content.

**BMV** · 03-11-2020, 01:37 PM

Please Login or Register  to view this content.

Excel VBA code to Average Non Zeros for Multiple Ranges

LinkBack

Thread Tools

Rate This Thread

Display

Excel VBA code to Average Non Zeros for Multiple Ranges

Re: Excel VBA code to Average Non Zeros for Multiple Ranges

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Averageif, not counting zeros, but in multiple ranges)

How do I average multiple columns (ignoring zeros and blank cells)?

AVERAGE - Multiple VLOOKUPs whilst ignoring zeros or blanks

[SOLVED] Averaging across multiple ranges, not counting zeros, and the [h]:mm format

[SOLVED] how to average multiple averages that can contain zeros

[SOLVED] How do I get the average across multiple cells not in a range and not count the zeros/text

[SOLVED] Average for non-consecutive cells excluding zeros (even when they all contain zeros)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions