hi,
I've developed a function that will count the number of items in a column between two dates. The function works fine at the moment:
=COUNTIF(Sheet1!U:U,"<="&DATE(2004,11,31))-COUNTIF(Sheet1!U:U,"<"&DATE(2004,11,1))
I now want to modify the function so it only counts between two dates if the name in column D matches for example 'Danny'. How would I go about this?
thanks