Function to count non-contiguous cells in a column and sums the cells

[Ace of Clubs]

Hey,

I am trying to write a function for a cell that counts non-contiguous cells in a column and then sums them together. The issue is this cell will be copied to multiple worksheets and will have to re-count all the cells when it is copied.

This is my first time writing a function.

Thanks in advance

[Domenic]

Can you provide a small sample of the data, along with the expected result?