Let's say your data is in A2:B1800

=SUMPRODUCT(--(YEAR(A2:A1800)=YEAR(TODAY())),--(MONTH(A2:A1800)=MONTH(TODAY())),--(B2:B1800 < 0))/COUNTA(A2:A1800)
--
HTH,
Barb Reinhardt



"brian.mccreery" wrote:

Hi, I am stuck trying to simplify formula. Have Excel 2007 and want to use
COUNTIFS ? to incorporate dates in column D for the current month. total rows
currently 1800
D L
02/08/2007 -1
01/09/2007 3
02/10/2007 4
04/10/2007 -3

This is my current working formula without using month

COUNTIF(L:L,"0")/(COUNTIF(L:L,"0")+COUNTIF(L:L,"<0"))

many thanks if someone can help