counting ranges with multiple variables
 

I'M TRYING TO COUNT A CERTAIN RANGE OF NAMES.

LEWIS MARQUITA 68
HAGANS LESLIE L 68
TYLER BRET J 67
NIMMONS SORENZO 67
GADSON GWENDOLY 65
RICKS KENNETH B 65
PONDER DENISE 65
CALLAWAY HENRY 65
LEE APRIL 64
BETTAC NATHAN D 64
CAMPBELL TAMMYE 64
PIPER SABRINA 64
SALAAM MAJID S. 64
RAMER CURTIS 64
TURNER REGINA B 64
TAYLOR JEFFREY 64
MARINO GEORGE W 63
ELLISON-COHEN E 63
WILLIAMS TIFFAN 62
DOUGLAS STEVEN 62
ROBINSON SABRIN 62
JACKSON RANDREA 61
DIXON RACHEL L 61
BRYANT-FELLS CA 61
STEWART TOMIKA 61
COLE ELIZABETH 61
COLLINS LAURA A 61
PARKER KATHLEEN 61
WILLIAMS LATOYA 61
ROBINSON JOHNNE 61
WALTERS TOMMIE 61
BUCHLER JUSTIN 61
PATTEN CURTIS L 61


I WANT TO BE ABLE TO COUNT THE NUMBER OF NAMES WITHIN THE RANGE OF #S. FOR
EXAMPLE. WITHIN THE RANGE OF 61 TO 68, HOW MANY NAMES ARE WITHIN THE RANGE
OF LAST NAME LEWIS TO WALTERS?

counting ranges with multiple variables
 

=SUMPRODUCT(--($A$2:$A$5000="Lewis"),--($A$2:$A$5000<="Walters"),--($B$2L$B$5000=61),--($B$2L$B$5000<=68))

All ranges must be the same, and cannot select entire column, must pick a
range within the column.

P.S. - Please remove caps lock.


"GAIDEN" wrote:

I'M TRYING TO COUNT A CERTAIN RANGE OF NAMES.

LEWIS MARQUITA 68
HAGANS LESLIE L 68
TYLER BRET J 67
NIMMONS SORENZO 67
GADSON GWENDOLY 65
RICKS KENNETH B 65
PONDER DENISE 65
CALLAWAY HENRY 65
LEE APRIL 64
BETTAC NATHAN D 64
CAMPBELL TAMMYE 64
PIPER SABRINA 64
SALAAM MAJID S. 64
RAMER CURTIS 64
TURNER REGINA B 64
TAYLOR JEFFREY 64
MARINO GEORGE W 63
ELLISON-COHEN E 63
WILLIAMS TIFFAN 62
DOUGLAS STEVEN 62
ROBINSON SABRIN 62
JACKSON RANDREA 61
DIXON RACHEL L 61
BRYANT-FELLS CA 61
STEWART TOMIKA 61
COLE ELIZABETH 61
COLLINS LAURA A 61
PARKER KATHLEEN 61
WILLIAMS LATOYA 61
ROBINSON JOHNNE 61
WALTERS TOMMIE 61
BUCHLER JUSTIN 61
PATTEN CURTIS L 61


I WANT TO BE ABLE TO COUNT THE NUMBER OF NAMES WITHIN THE RANGE OF #S. FOR
EXAMPLE. WITHIN THE RANGE OF 61 TO 68, HOW MANY NAMES ARE WITHIN THE RANGE
OF LAST NAME LEWIS TO WALTERS?

counting ranges with multiple variables
 

Didn't work. I get the following error message. #VALUE!

"Sean Timmons" wrote:

=SUMPRODUCT(--($A$2:$A$5000="Lewis"),--($A$2:$A$5000<="Walters"),--($B$2L$B$5000=61),--($B$2L$B$5000<=68))

All ranges must be the same, and cannot select entire column, must pick a
range within the column.

P.S. - Please remove caps lock.


"GAIDEN" wrote:

I'M TRYING TO COUNT A CERTAIN RANGE OF NAMES.

LEWIS MARQUITA 68
HAGANS LESLIE L 68
TYLER BRET J 67
NIMMONS SORENZO 67
GADSON GWENDOLY 65
RICKS KENNETH B 65
PONDER DENISE 65
CALLAWAY HENRY 65
LEE APRIL 64
BETTAC NATHAN D 64
CAMPBELL TAMMYE 64
PIPER SABRINA 64
SALAAM MAJID S. 64
RAMER CURTIS 64
TURNER REGINA B 64
TAYLOR JEFFREY 64
MARINO GEORGE W 63
ELLISON-COHEN E 63
WILLIAMS TIFFAN 62
DOUGLAS STEVEN 62
ROBINSON SABRIN 62
JACKSON RANDREA 61
DIXON RACHEL L 61
BRYANT-FELLS CA 61
STEWART TOMIKA 61
COLE ELIZABETH 61
COLLINS LAURA A 61
PARKER KATHLEEN 61
WILLIAMS LATOYA 61
ROBINSON JOHNNE 61
WALTERS TOMMIE 61
BUCHLER JUSTIN 61
PATTEN CURTIS L 61


I WANT TO BE ABLE TO COUNT THE NUMBER OF NAMES WITHIN THE RANGE OF #S. FOR
EXAMPLE. WITHIN THE RANGE OF 61 TO 68, HOW MANY NAMES ARE WITHIN THE RANGE
OF LAST NAME LEWIS TO WALTERS?