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

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

T. Valko

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<>""))
 
C

Corey ....

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

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

Combo text value disappears when wkb opens??! 2
Enabling Macros message when NO macros in workbook 3
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Building Macros in 2003 and Running in 2007 1
Global Template Network and saving auto texts & macros 2
Subtotals in Excel 2007 0
ENABLE MACROS 2
security, enabling macros to enable a disabling saving function 12

Top