I have tried the suggested Excel 2003 solution to the Countifs function but
am getting stuck.

I want to count the number of tems in a spreadsheet where two predefined
conditions are met so where the month = x and where the status is "1"

My original formula is: =_xlfn.COUNTIFS('HB Appeals'!$E$2:$E$65536,"=5",'HB
Appeals'!$L$2:$L$65536,"=1") as I had it sorted on Excel 2007.

I have tried: =SUMPRODUCT("--('HB Appeals'!e2:E200,4)","--('HB
Appeals'!L2:L200,1)") as suggested but I am getting nowhere.

Please adise