Excel: Total Count of Cells Across Multiple Worksheets Formula
excel, excel-formula
Solution
=CountIF(C2:C32,"<>"&"")
should do what you want.
For multiple pages, do a countIf for each page example -
=CountIF('Sheet1'!C2:C32,"<>"&"")+CountIF('Sheet2'!C2:C32,"<>"&"")
This will work to give you the number of cells with values, if you want to add the values together please specify that in your question and I can fix the answer
Problem
I have an Excel workbook with multiple worksheets, each worksheet represents a calendar month starting with May_2013 and ending with December_2013. I want to count only the cells within C2-C32 in each worksheet that contains data and omit the cells without data. I am completely useless when it comes to Excel. Any solutions/suggestions would be greatly appreciated. Thanks a lot!