Prime and Composite numbers

Dear Excel Experts,

I have numbers in A2, B2, C2, D2, E2, F2 and would like to count how many Prime and Composite numbers are there. For instance 2, 3, 4, 5, 6, 7 = 4/2

And also would like to know all numbers put together is Prime or Composite. For Instance, 2, 3, 4, 5, 6, 7 =Composite (because all numbers put together is 234567)

Appreciate if somebody could provide me a formula for both the above scenarios.

Thanks in advance