Hello everyone, I'm new to this forum and looking for help.
I have a row, like this one:
How can I calculate the average of non-zero 5-10 values (I marked them in bold)?
Thank you a lot,
I have a row, like this one:
0 | 2 | 0 | 1 | 2 | 7 | 8 | 1 | 0 | 3 | 0 | 1 | 0 | 3 | 0 | 4 | 8 | 0 |
How can I calculate the average of non-zero 5-10 values (I marked them in bold)?
Thank you a lot,