Results 1 to 12 of 12

Sum every nth Column . Help needed

Threaded View

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    Italy
    MS-Off Ver
    2017
    Posts
    6

    Sum every nth Column . Help needed

    Greetings everyone and thank you in advance :-)

    I need a formula .
    Range D10 to XC10

    In XD10 I need a formula to sum values every 6 columns
    ( D10+J10+P10 and so on)

    I tried "=SUM(IF(MOD(COLUMN(D$10:XC$10),6 = 1,D10:XC10,0)))" (CTRL_SHIFT_ENTER)

    Excel gives me error and the error highlited is ",6"

    In XE10 I will need the same but starting from E10
    Last edited by AliGW; 01-15-2019 at 05:53 PM. Reason: [SOLVED]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula needed that 1st column only show number not in 2nd column.
    By jp16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2018, 01:55 AM
  2. Macro Needed for contains word in column a insert mark in column b
    By melisaball in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2015, 10:45 AM
  3. Replies: 4
    Last Post: 05-03-2014, 07:09 AM
  4. Replies: 4
    Last Post: 08-01-2012, 08:55 AM
  5. Help needed on Column & Row Headings
    By mkf in forum Excel General
    Replies: 0
    Last Post: 05-09-2006, 06:12 AM
  6. Compare one Column to a Second Column Formula Help Needed
    By jeffc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 10:30 AM
  7. help needed with text to column
    By Lisap in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2005, 01:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1