Take a look at SumProduct instead...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Saylindara" wrote:

I've got the following formula to sum referrals received in a particular month.

Is it possible to make it specific to the year as well as the month?

=SUM(IF(Referrals!$D$4:$D$10002='Referrals
List'!$A5,IF(Referrals!$J$4:$J$10002=MONTH($B$2),1 ,0)))