Results 1 to 11 of 11

Automate sum of every second cell in same row.

Threaded View

  1. 03-16-2017, 07:48 AM #1
    dexcel99
    dexcel99 is offline
    Registered User
    Join Date
    03-16-2017
    Location
    Victoria, Australia
    MS-Off Ver
    15.26
    Posts
    4

    Automate sum of every second cell in same row.

    Hi guys,

    Please see the attached photo.
    Screen Shot 2017-03-16 at 10.37.26 pm.png

    In row 2, I will be constantly entering figures in every second cell (B2, D2, F2 etc.). In cell B5 will be where the total of those figures will be. Cells C2, E2, G2 etc. will have values that won't be part of the calculation. I am seeking for a formula that will AUTOMATE the sum of the cells B2, D2, F2, H2, J2 etc.

    Thanks
    Last edited by dexcel99; 03-16-2017 at 08:26 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automate cell-by-cell averaging across multiple worksheets?
    By xu9j2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2016, 09:33 PM
  2. Find word/phrase within cell & automate putting value in adjacent cell
    By jyeg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2016, 10:44 AM
  3. [SOLVED] If Yes in one cell, Then automate No in two other cells
    By mmallard in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-03-2015, 06:35 PM
  4. [SOLVED] Automate a cell to show an answer if another cell says something else.
    By Tinwelende in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 05-10-2014, 07:31 AM
  5. [SOLVED] How can I automate the duplication of a row when the use tabs out of the last cell?
    By AAbrams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2013, 10:56 AM
  6. vba to automate naming cell ranges
    By RAH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2008, 01:13 PM
  7. Automate cell selection
    By mayanklal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2006, 11:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1