All functions I tried worked cross-sheet except AVERAGEIF and COUNTIF, so I am assuming this is a bug. If AVERAGEIF would work this would be so simple. I am away from home right now but will send the formula tomorrow.
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
All functions I tried worked cross-sheet except AVERAGEIF and COUNTIF, so I am assuming this is a bug. If AVERAGEIF would work this would be so simple. I am away from home right now but will send the formula tomorrow.