Sorry but I mucked up what I meant was row 1 and 2 not A and B.

Ms-Exl-Learner- This will count the L without any reference to the date in
row 1.
I want to count for L on row 2 only if it falls within a specified date
range on row 1
--
Cheers
Pappa Smurf


"Ms-Exl-Learner" wrote:

Just try this...

=COUNTIF(B2:F2,"L")

Change the Cell reference B2:F2 to your desired range.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Pappa" wrote:

Hi

I am attempting in Excel 2003 to lookup a date range in row A and then count
leave booked in row B. e.g.
01 02 03 04 05
TIM L L L
KIM L L

Count leave for Tim period 02 to 04 inclusive. (L's for leave could be
replaced with numeric)

Please note that

1. The date range would be entered in two seperate cells not directly into
the function.
2. The date period in row A would be running for a year so any function
would need to search the entire period.
--
Cheers
Pappa Smurf