Formual not working when 2003 WKB saved as 2007 Macro Enabled WKB

  • Thread starter Thread starter Corey ....
  • Start date Start date
C

Corey ....

=SUM(IF(MOD(ROW(A24:A210)-25,4)=0,1*(A24:A210<>"")))


Is there any reason the above forumal will not work in 2007?

Corey....
 
It works ok for me in Excel 2007.

You can also use this normally entered version:

=SUMPRODUCT(--(MOD(ROW(A24:A210)-25,4)=0),--(A24:A210<>""))
 
Thanks for the reply Biff.
I pasted the normally entered verion you posted, and it worked as the other
should have.

Thank you

Saved me lots of time and energy.

Cheers


Corey....
 
Back
Top