Don't understand where E2 and the OFFSET come into it.
It is easy to count how many Hols come into the specified dates, and
multiply by 8, but the rest?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Simon Lloyd"
wrote in message
...
Hi al,
Is it possible to write a formula like the one below? of course the one
below doesnt work, but i need the formula to count the value in the cell
(in this example its E2) but only if the date lies between certain dates
in column A, so it would count in multiples of eight each instance of a
text found between the first 2 dates and in multiples of 12 in the 2nd
two dates etc.
=COUNTIF(Hols,E2 OFFSET(0,5) =1/1/06 or <=17/4/06)*8+COUNTIF(Hols,E2
OFFSET(0,5) =18/4/06 or <=8/10/06)*12+COUNTIF(Hols,E2 OFFSET(0,5)
=9/10/06 or <=31/12/06)*8+F2
Anyone know how?
Hope you can help
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=499674