Articles

Solved Need COUNTA formula based on IF situation

January 22, 2013 at 11:53:54
Specs: Windows 7

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?

See More: Need COUNTA formula based on IF situation

Report •


#1
January 22, 2013 at 12:01:44
✔ Best Answer

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?


Report •

#2
January 22, 2013 at 12:06:05

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

Report •

#3
January 22, 2013 at 12:27:00

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

Report •

Related Solutions


Ask Question