Stupid Excel Question

Ghoulish Delight · 03-24-2007, 03:14 PM

I presume the list of counties doesn't change month to month? If so, for each county, create a cell with "=countif(range, county name)". So, if the column with the county names is H, to count the number of entries for county Alpha, you'd put "=countif(H:H, Alpha)".

Kevy Baby · 03-24-2007, 05:55 PM

Quote:

Originally Posted by Ghoulish Delight

I presume the list of counties doesn't change month to month?

Ironically, the counties are not supposed to change. But that is what I am checking: to see if the list company did their job properly each month and included only the counties that they are supposed to.

03-24-2007, 03:14 PM	#1
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	I presume the list of counties doesn't change month to month? If so, for each county, create a cell with "=countif(range, county name)". So, if the column with the county names is H, to count the number of entries for county Alpha, you'd put "=countif(H:H, Alpha)". __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes