+ Reply to Thread
Results 1 to 3 of 3

Sum Every Other Column Only Where Adjacent Column is non-Empty cell

Hybrid View

sas5610 Sum Every Other Column Only... 05-12-2023, 06:06 PM
Estevaoba Re: Sum Every Other Column... 05-12-2023, 07:37 PM
leelnich Re: Sum Every Other Column... 05-12-2023, 09:03 PM
  1. 05-12-2023, 06:06 PM #1
    sas5610 is offline
    Registered User
    Join Date
    05-05-2023
    Location
    United Arab Emirates
    MS-Off Ver
    Microsoft 365
    Posts
    16

    Sum Every Other Column Only Where Adjacent Column is non-Empty cell

    Hi, I am looking for a formula to sum up numbers in a table where I need have every other column value to be summed up only if adjacent column is a non-empty cell.
    I have attached file for your reference.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-12-2023, 07:37 PM #2
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,508

    Re: Sum Every Other Column Only Where Adjacent Column is non-Empty cell

    Maybe:
    Formula: copy to clipboard 
    =SUMIFS(A5:I5,A3:I3,"TGT",B3:J3,"ACT",B5:J5,">0")

    Good luck!
    Reply With QuoteRegister To Reply
  3. 05-12-2023, 09:03 PM #3
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Sum Every Other Column Only Where Adjacent Column is non-Empty cell

    I think Estevaoba has it, but you can shorten his formula a little:
    Formula: copy to clipboard 
    =SUMIFS(A5:I5,A3:I3,"TGT",B5:J5,">0")
    No need to check for ACT, the offset ranges already yield proper alignment.
    Last edited by leelnich; 05-12-2023 at 09:06 PM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Problem with counting item in adjacent cell if the cell in a particular column is empty
    By stlee96 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2021, 06:43 AM
  2. [SOLVED] Fill a column with a formula up to an empty adjacent cell
    By dburge07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2021, 02:31 PM
  3. [SOLVED] Copy last used column to adjacent empty column
    By itwas45and51 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2015, 11:42 PM
  4. How to Populate an Empty Cell with Values from Adjacent Same Record But Different Column
    By lyndy256 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2013, 10:27 PM
  5. [SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.
    By naga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2013, 07:44 AM
  6. Fill empty cells per adjacent column
    By ElmerS in forum Excel General
    Replies: 11
    Last Post: 10-20-2010, 05:56 PM
  7. Insert data from one column into the empty cells of an adjacent column
    By kisboros in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2010, 02:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1