SMANDA

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using countif function to add only a half of a number	ryanjh79	Excel Discussion (Misc queries)	9	April 26th 23 03:42 AM
countif function	etan	Excel Worksheet Functions	5	February 7th 05 12:55 AM
Advanced COUNTIF Function	License Boy	Excel Worksheet Functions	3	December 8th 04 02:23 PM
The countif function in Excel 2002.	Lounsbud	Excel Worksheet Functions	1	November 22nd 04 03:19 PM
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION	Marty	Excel Worksheet Functions	1	November 11th 04 09:45 PM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us