counting with different criteria

**snowee01** · 07-14-2009, 10:06 PM

can someone help with this

I need to seperate and count two different criterias.
In my mthly work sheet Column F is desiginated to engineer 3 number codes and contractors which are 2 numeric and 1 alpha.

the engineer codes seem to be from 100 -500
examples of contractor codes are 26B,24T,25E etc.

How can I count only the 3 number engineer codes?

snowee01

**Paul** · 07-14-2009, 10:46 PM

Hi Snowee,

To count just the numbers in column F, use:
=COUNT(F2:F100)

To count just the non-numeric cells, use:
=COUNTA(F2:F100)-COUNT(F2:F100)

Adjust your range as needed. COUNT only counts numbers, while COUNTA counts all cells with text (including numbers), which is why we subtract the number count to get that total.

Hope that helps!

**snowee01** · 07-14-2009, 11:29 PM

thanks for your help Paul, however we have hit another snag, when we used your great tip we discovered that all cells have been converted to text straight from "Pronto's report building - we can not change column to 'Numeric' any ideas to get around this

**mewingkitty** · 07-14-2009, 11:36 PM

Something like:

Please Login or Register  to view this content.

Will coerce the third character into a recognizable number, if it is indeed a number, and return TRUE, but will return FALSE if it's a letter.

Hope that helps?