Yandeez Member Aug 28, 2014 #1 Hi, I believe I need a formula that counts the cells that are not blank from two sheets. I need that number to update automatically as I add new records. Any and all help is helpful!
Hi, I believe I need a formula that counts the cells that are not blank from two sheets. I need that number to update automatically as I add new records. Any and all help is helpful!
Yandeez Member Aug 28, 2014 #2 Nevermind...Countif did it. I need a formula that counts the number of times a name appears.
Luke M Excel Ninja Staff member Aug 28, 2014 #3 You can also use COUNTA to count non-blank cells. Do you still have a question, or did you answer it?
You can also use COUNTA to count non-blank cells. Do you still have a question, or did you answer it?
