Question

Hello,

Is there a way to count the number of pages in a Notion database and then use the value in another database?

Answer 1

Relate the 2 databases and create a rollup to pull the SUM you need.

That will do exactly what you need.