How to apply formula before the SUM()?

Question

I want to do sum() operation. For example sum(A1:A100) BUT I want to apply other function() for every cell before the sum() operation. How to do this without extra additional cells.

For example the function to check if the value is bigger than 1 then it will convert it to 1. Or convert whatever number in the cell into 1.

something like:

= A1/A1 + A2/A2 + A3/A3 ... A100/A100

but I want to do it inside sum(). is it possible?

Answer 1

maybe like:

=ARRAYFORMULA(SUM(N(ISNUMBER(A:A))))

---

or maybe:

=COUNTA(FILTER(A:A, A:A*1))