Glad to have been able to help.
--
David Biddulph

"Bradley Searle" wrote in message
...
Pete / David - Thank you so much for the quick reply! Your solutions
worked
perfectly. Very impressed!

"David Biddulph" wrote:

=SUMPRODUCT(('Pre-Sales & WIP'!E1:E100=Analysis!C1)*('Pre-Sales &
WIP'!E1:E100<Analysis!C2)*('Pre-Sales & WIP'!B1:B100="WIP"))
--
David Biddulph

"Bradley Searle" <Bradley wrote in
message
...
Hi,

I'm trying to count the number of occurances of a value between two
dates
that I specify.

I've done this by using the following formula and it works:

=COUNTIF('Pre-Sales & WIP'!E:E,"="&Analysis!C1)-COUNTIF('Pre-Sales &
WIP'!E:E,"="&Analysis!C2)

The dates are on sheet 'Analysis' in C1 and C2. The dates are in
column E
on sheet 'Pre-Sales & WIP'.

Problem - Although this works I want it to only do the count when a
value
in
column B on sheet 'Pre-Sales & WIP' equals "WIP" (for example).

I added an IF function to the beginning of my formula but this only
told
it
to perform the calculation if column B contained the word "WIP"
anywhere.
I
want it to count the values for every occurance of the word "WIP".

eg:

WIP - Between Correct Dates Specfied = Count
(another word) - Between or Not Between Dates Specified = No Count

I do hope this makes sense, any help appreciated!