Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula to find the occurances of a number that is greater than one number but less than another
Hi guys, I have a range where I need to find the occurance of a number
greater than 10500 but less than 13500 and I think it should look like this: =countif(d5:d3200,10500,<13500) would that be right as far as syntax etc? Also how would I copy this formula through multiple worksheets (one workbook, whereby the formula moves down 1200 cells continuously to the end of the worksheet and hopefully replicates in the same spots in ultiple worksheets to the end of the workbook? The cell references remain relative throughout. As always I appreciate any help you can give me. Thanks!! steveo It shouldn't make any difference but this is excel 2004 mac. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula to find the occurances of a number that is greater than one number but less than another
try this
=SUMPRODUCT((A1:A910500)*(A1:A9<13500)) A1 to A9 is the data.; modify to suit you. "steveo" wrote in message ups.com... Hi guys, I have a range where I need to find the occurance of a number greater than 10500 but less than 13500 and I think it should look like this: =countif(d5:d3200,10500,<13500) would that be right as far as syntax etc? Also how would I copy this formula through multiple worksheets (one workbook, whereby the formula moves down 1200 cells continuously to the end of the worksheet and hopefully replicates in the same spots in ultiple worksheets to the end of the workbook? The cell references remain relative throughout. As always I appreciate any help you can give me. Thanks!! steveo It shouldn't make any difference but this is excel 2004 mac. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula to find the occurances of a number that is greater than one number but less than another
=COUNTIF(D5:D3200,"10500")-COUNTIF(D5:D3200,"=13500")
Just copy and past and Excel will adjust it to wherever you paste. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "steveo" wrote in message ups.com... Hi guys, I have a range where I need to find the occurance of a number greater than 10500 but less than 13500 and I think it should look like this: =countif(d5:d3200,10500,<13500) would that be right as far as syntax etc? Also how would I copy this formula through multiple worksheets (one workbook, whereby the formula moves down 1200 cells continuously to the end of the worksheet and hopefully replicates in the same spots in ultiple worksheets to the end of the workbook? The cell references remain relative throughout. As always I appreciate any help you can give me. Thanks!! steveo It shouldn't make any difference but this is excel 2004 mac. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula to find the occurances of a number that is greater than one number but less than another
Bob Phillips wrote: =COUNTIF(D5:D3200,"10500")-COUNTIF(D5:D3200,"=13500") Just copy and past and Excel will adjust it to wherever you paste. Thanks bob, any idea how to make that formula repeat every 1200 cells down in the worksheet and then continue in the exact sme places in several other worksheets to the end of the workbook without having to manually copy it? steveo -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "steveo" wrote in message ups.com... Hi guys, I have a range where I need to find the occurance of a number greater than 10500 but less than 13500 and I think it should look like this: =countif(d5:d3200,10500,<13500) would that be right as far as syntax etc? Also how would I copy this formula through multiple worksheets (one workbook, whereby the formula moves down 1200 cells continuously to the end of the worksheet and hopefully replicates in the same spots in ultiple worksheets to the end of the workbook? The cell references remain relative throughout. As always I appreciate any help you can give me. Thanks!! steveo It shouldn't make any difference but this is excel 2004 mac. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
What is the Formula to find the Media of a number of cells? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) |