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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 01:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com