Hi,

I have this function =SUM(IF($D$25:$D$993="x",IF($B$25:$B$976=""&A3,1), 0))
from excel 2003 and now have converted the spreadsheet to 2007.

I have inserted rows and now need to change $D$25 and $b$25 to reference row
22.

Or is there a better way to do this. count number of x's from d22:d900 if
b22:b900 equals a3.