Cells are read when you run. Manual fills only; hidden and filtered cells are included. Results are snapshots: run again after editing cells or colors.
Help Function reference