I need a formula that will pull in the counta values of the number of rows that have a number listed in a certain column (E). Some fields are blank within column E and I do not want to count these in the formula. Can someone help?

Hi If you use the Count function (as opposed to Counta) it will count only numerical values and ignore alphas and blanks. Or am I missing something?

Oh my... that was a duh moment. Thank you! My mind has been swirling today. That worked perfectly.

No worries. That's why we're here - to get you past those duh moments as quickly as possible.

Ask Your Question

Weekly Poll