ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif function with variables (https://www.excelbanter.com/excel-worksheet-functions/11990-countif-function-variables.html)

SMANDA

Countif function with variables
 
In Excel 2000 I was able to do this:
Col.A has a sequence of 1000 random numbers
Col. B has bin values (like in the histogram definition)
Using Indirect and countif funcitons, I could compute the
number of values in Col A between B1 and B2 and so on.

I am not able to do this in Excel 2003.
Need help to recreate the old behavior
thanks in advance
manda


All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com