Support Board
Date/Time: Tue, 01 Jul 2025 06:04:44 +0000
Post From: Average of non-zero values in a spreadsheet
| [2013-05-10 12:48:48] |
| 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)) |