| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text box format missing when saved from 2007 to 2003 | Charts and Charting in Excel | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
| Using Excel 2007 saved as 97-2003 | Excel Discussion (Misc queries) | |||
| need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
| Default a workbook to save as a xlsm (macro-enabled) in 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
