Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 22:48:46 +0000

How to Post a Message for Support

Post From: Average of non-zero values in a spreadsheet

[2013-05-10 12:48:48]
[Go To First Post]
vegasfoster - Posts: 444
Also if you wanted to use multiple conditions, e.g. not zero and less than 500, then you could use something like

=SUMPRODUCT(--(A1:A10<>0), --(A1:A10<500), A1:A10)/SUMPRODUCT(--(A1:A10<>0), --(A1:A10<500))