79557743

Date: 2025-04-06 02:47:37
Score: 2
Natty:
Report link

I use Aggregate. There are number choices, 1 is Average I believe. It'll only calculate on the visible rows.

It'd look like this. =Aggregate (1,5,your array)

Hope that helps.

Reasons:
  • Whitelisted phrase (-1): Hope that helps
  • Low length (1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Blane