Could somebody explain to me why this formula is not counting my data.

SUMPRODUCT((Projected!I:I="Pilot")*(Projected!O:O= "FY2009-Q4"))

I think I have written it correctly. I am trying to have the formula look
at a worksheet and count if the cell in row I equals pilot and the cell in
row O equals FY2009-Q4. For some reason excel is not able to calculate the
formula.

On a note, this formula used to calculate, but I have a macro select all the
cells and delete before importing the data with column headers and
formatting. After I deleted the cells and repasted the new data, it is not
calculating even after I engage a recalc. Any help would be appreciated.