Count the Number of Column Criteria Met

[rwmill9716]

I have a table that has 1,000 rows. Each of the Gold columns (L, M, O, P, Q, R, X, AB, AE, AF) has a target that if met will add 1 to the count in column E.
Column/Target: L/1, M/A, O/>0, P/>0, Q/>0, R/<1.5, X/<1, AB/>0, AE/<0, AF/<-15

I need a macro that sums the count in column E for each row.

 

[awoohaw]

What is the reason you need to do this with a macro? this can be done with a formula.
Is it that you just don't want a formula in column E?

 

[rwmill9716]

Thanks, I would rather do it with a formula, a series of CountIF statements. I hadn't thought of that.

 

[awoohaw]

okay,
try this:

Book1
	E							L	M		O	P	Q	R						X				AB			AE	AF
1	Target:							1	A		>0	>0	>0	<1.5						<1				>0			<0	<-15
2	10							1	A		1	1	1	1						0				1			-1	-16
Sheet1

Cell Formulas
Range	Formula
E2	E2	=(L2=1)+(M2="A")+(O2>0)+(P2>0)+ (Q2>0)+(R2<1.5)+(X2<1)+(AB2>0)+(AE2<0)+(AF2<-15)