| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a number that is less than a number and greater than a numbe
How do i do this? I want to count numbers is a range of cells that is greater
than 19 and less than 29. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count a number that is less than a number and greater than a numbe
Will something like this work for you?
=COUNTIF(A1:A100,"<29") -COUNTIF(A1:A100,"<=19") €¢€¢€¢€¢€¢€¢€¢€¢€¢€¢ Regards, Ron "Dale" wrote: How do i do this? I want to count numbers is a range of cells that is greater than 19 and less than 29. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count a number that is less than a number and greater than a numbe
Assuming you really mean COUNT and not ADD;
a) =COUNTIF(A1:A100,"19") - COUNTIF(A1:A100,"29") b) =SUMPRODUCT(--(A1:A10019), --(A1:A100<29)) but if you do want to sum: a) =SUMIF(A1:A100,"19") - SUMIF(A1:A100,"29") b) =SUMPRODUCT(--(A1:A10019), --(A1:A100<29), A1:A100) best wishes Bernard "Dale" wrote in message ... How do i do this? I want to count numbers is a range of cells that is greater than 19 and less than 29. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count a number that is less than a number and greater than a numbe
From the spec, that should be =29.
-- HTH RP (remove nothere from the email address if mailing direct) "bernard liengme" wrote in message ... Assuming you really mean COUNT and not ADD; a) =COUNTIF(A1:A100,"19") - COUNTIF(A1:A100,"29") b) =SUMPRODUCT(--(A1:A10019), --(A1:A100<29)) but if you do want to sum: a) =SUMIF(A1:A100,"19") - SUMIF(A1:A100,"29") b) =SUMPRODUCT(--(A1:A10019), --(A1:A100<29), A1:A100) best wishes Bernard "Dale" wrote in message ... How do i do this? I want to count numbers is a range of cells that is greater than 19 and less than 29. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Hybrid Mode
