Excel sum formula

Occasional Visitor

I'm want to not only use the AutoSum (which is working fine) but also count/sum the number of Constants in the AutoSum formula to ensure every line was entered. Does this make sense? Can anyone tell me how to write this, I'm assuming probably simple, formula?

1 Reply



The COUNT function should do what you want. https://exceljet.net/excel-functions/excel-count-function


If that's NOT what you're looking for, it would help if you posted a copy or a resemblance of your actual spreadsheet, along with a more complete description of what you are looking to do, and why COUNT isn't the solution.


I ask that because your request is a bit ambiguous. For example, you use and even capitalize the word "Constants" -- but SUMS often include variables as well,  and COUNT would include them, but it might appear that you don't want variables to be counted. You see the potential for confusion.