Awesome post today from the Microsoft Excel team…
Adding Every Other Cell in a Column
Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel.
Jenny asks "Is there a quick way of adding every other cell ?, I have a column of about 250 cells, and I have to select them manually using Ctrl. Can you help ?"
Jenny, this is a matter of using a little math to remember how to determine if a number is even or is odd, and then translate that into the formula.
The formula
=MOD(A1,2)
would return 0 if the number is even and 1 if odd. If we use instead of A1, the ROW() function, we can know if a particular row is even or odd. Now, suppose you're trying to calculate this formula
=A1+A3+A5+A7+A9 ... etc.
or this one
=SUM(A1,A3,A5,A7...)
=SUM((MOD(ROW(A1:A250)-ROW(A1),2)=0)*(A1:A250))
Remember, this is a CSE Formula, to enter it you must press at the same time Control Shift Enter, instead of just Enter as regular formulas.
You can also use this non-array formula
=SUMPRODUCT((MOD(ROW(A1:A250)-ROW(A1),2)=0)*(A1:A250))
MrExcel provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
http://blogs.msdn.com/excel/archive/2009/09/24/adding-every-other-cell-in-a-column.aspx
Note: I’ve been a fan of Excel for about 20 years now.
We used it as the data backbone for a Voice Recognition System for Mazda.
That early version of Excel worked great on the networks we designed.
This was all pre-Internet, before SQL Server. Awesome memories.
Freddy Kristiansen, PM Architect on the Microsoft Dynamics NAV team, just posted an awesome article about a very handy tool you can D/L right now called ComponentHelper.
Scenario:
When you install the RoleTailored Client on a number of clients, you might need to install a number of Client side components as well. This might not sound as too much of a problem when you need to install the client anyway – but lets say you install an ISV Add-on with a live customer, who already have 100 clients install – and now you need to install the objects to the database – AND you need to run to 100 computers and install Client side components.
Yes, you can do this with system management policies, but not all customers are running SMS and it would just be way easier if everything could be handled from the ISV Add-On and the Client Components could be auto deployed.
When doing this – it is still important, that IF the customer is running SMS and decide to deploy the Client Side components through system policies – then the auto deployment should just pick this up and accept that things are Ok.
Read more here…
Auto deployment of Client Side Components