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

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

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

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

--
Biff
Microsoft Excel MVP


"Corey ...." wrote in message
...
=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....

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

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

"T. Valko" wrote in message
...
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<""))

--
Biff
Microsoft Excel MVP


"Corey ...." wrote in message
...
=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....

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Corey ...." wrote in message
...
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....

"T. Valko" wrote in message
...
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<""))

--
Biff
Microsoft Excel MVP


"Corey ...." wrote in message
...
=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....