Posted to microsoft.public.excel.misc

dellbad

external usenet poster

Posts: 4

Counting Data From 2 Different Columns

Please see example below:

Fiscal Year Lead Time (Days)
======================
FY05 11
FY05 23
FY05 16
FY06 14
FY06 21
FY06 35
FY07 8
FY07 26
FY07 33
======================

I need a formula that will allow me to count the # of records above that are
(for example) in FY05 and fall between 10 and 20 days. The answer should be
(2).

Thanks in advance for you help.

Dellbad

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
Counting in two columns	PedersenJ	Excel Worksheet Functions	3	August 8th 06 12:24 AM
Counting data columns with dates	Manni	Excel Discussion (Misc queries)	2	April 11th 06 02:05 PM
Counting data in columns	telewats	Excel Discussion (Misc queries)	1	February 21st 06 03:35 PM
Counting columns of dates	mango7	Excel Discussion (Misc queries)	4	December 9th 05 08:42 PM
counting columns	jpcblood	Excel Worksheet Functions	1	August 10th 05 12:41 AM

All times are GMT +1. The time now is 06:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us