View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAIDEN GAIDEN is offline
external usenet poster
 
Posts: 30
Default 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?