Support Board
Date/Time: Fri, 22 Nov 2024 13:04:32 +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)) |