I am looking to total up the same cell from multiple worksheets within a
workbook.

For instance, if I have 10 worksheets (one being the summation worksheet),
and a particular cell in 3 of those workbooks are populated with any type of
value, I want the summation worksheet to show 3. For clarity, I do not
want to add the value within the cells from multiple worksheets, just the
fact that the cell was populated with a value.

I know there is an answer out there but was not able to figure it out
myself. Thanks in advance.