Results 1 to 11 of 11

SUMPRODUCT with skipping columns and column Breaks

Threaded View

  1. 02-24-2018, 09:50 AM #1
    jhansrod
    jhansrod is offline
    Registered User
    Join Date
    09-05-2017
    Location
    Dubai
    MS-Off Ver
    2017
    Posts
    5

    Question SUMPRODUCT with skipping columns and column Breaks

    Hi All

    This is a follow up to a previous thread (SUMPRODUCT with skipping columns) with the difference that I have a column break between years whereby when I copy the working formula it does not work for the second year onward.

    Your assistance and guidance is appreciated as I have been breaking my head for a while now on this ....

    Thank you
    Junaid
    Attached Files Attached Files
    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. [SOLVED] SUMPRODUCT with skipping columns
    By jhansrod in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2018, 10:20 PM
  2. sumproduct with 3 columns -- need to multiply with one column
    By aqalna in forum Excel General
    Replies: 4
    Last Post: 10-20-2016, 09:55 PM
  3. sumproduct with 3 columns but need to multiply with one column
    By aqalna in forum Excel General
    Replies: 1
    Last Post: 10-20-2016, 09:51 PM
  4. Take the sumproduct of three columns (last column changing)
    By maistral in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2014, 02:14 AM
  5. Transposing Array into Single Column,Skipping blanks and skipping cells with specific text
    By TJS22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2014, 04:30 PM
  6. Sumproduct, skipping columns, addition
    By jayclinton in forum Excel General
    Replies: 2
    Last Post: 12-29-2008, 07:12 PM
  7. [SOLVED] Skipping cells when using SUMPRODUCT function
    By Jason in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09: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