Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Criteria in Cells in Multiple Ranges | Excel Worksheet Functions | |||
COUNTIF() With multiple ranges and variables | Excel Discussion (Misc queries) | |||
Counting multiple variables in a worksheet for summary on another | Excel Worksheet Functions | |||
Formula for counting multiple variables in a spreadsheet | Excel Worksheet Functions | |||
Counting multiple variables returns #VALUE | Excel Discussion (Misc queries) |