tag:blogger.com,1999:blog-1928376702114455780.post3162554187370607456..comments2022-03-30T09:50:44.832-07:00Comments on MS Office Experts: Write Custom Functions in Excel.Office Coderhttp://www.blogger.com/profile/05983801349001346764noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1928376702114455780.post-46181954737697874702010-07-21T10:56:37.800-07:002010-07-21T10:56:37.800-07:00Hi,
Oh yeah, we can write an array formula. That ...Hi,<br /><br />Oh yeah, we can write an array formula. That I already knew, and if you see, I have mentioned that you can write an Excel Built in formula for this requirement. But there may be some requirements, where we cannot realistically use the Excel Formula. I took this example not because we don't have any alternative, rather, this example is an easy to understand. I had intentionally opted for a simple example.<br /><br />Thanks,<br />VikasOffice Coderhttps://www.blogger.com/profile/05983801349001346764noreply@blogger.comtag:blogger.com,1999:blog-1928376702114455780.post-79812893513895153952010-07-21T06:22:43.473-07:002010-07-21T06:22:43.473-07:00You can use an array formula for this:
{=SUM(IF(M...You can use an array formula for this:<br /><br />{=SUM(IF(MOD(A1:A10,2)=0,A1:A10,0))}JPhttps://www.blogger.com/profile/06464959334594594876noreply@blogger.com