2003 function moved to 2007 unable to change absolute references

S

Sivart

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.
 
S

Sheeloo

You are not able to edit the formula? Is it working in 2003?

It is probably because one range ends at 993 and the other at 976... size of
both ranges should be same...

I prefer to use SUMPRODUCT in these cases like this
=SUMPRODUCT(--($D$22:$D$993="x"),--($B$22:$B$993=A3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not sure what function, macro, etc to use 2
translating countifs function to Excel 2003 4
Hyperlinks lost in Word 2003 to Word 2007 Conversion 3
problem with meeting invitation since we moved to exchange 2007 2
Conditional Formating/Excel 2007 to 2003 1
Indirect function 3
Excel - copy absolute cell references (within the range) as relati 1
unable to add row to Excel 2007 TABLE 3

Top