+ Reply to Thread
Results 1 to 13 of 13

SumIf across columns

Hybrid View

Lithium78 SumIf across columns 02-18-2010, 09:21 PM
teylyn Re: SumIf across columns 02-18-2010, 10:09 PM
Lithium78 Re: SumIf across columns 02-18-2010, 10:26 PM
teylyn Re: SumIf across columns 02-18-2010, 10:32 PM
Lithium78 Re: SumIf across columns 02-18-2010, 10:38 PM
teylyn Re: SumIf across columns 02-18-2010, 10:45 PM
Lithium78 Re: SumIf across columns 02-18-2010, 10:50 PM
teylyn Re: SumIf across columns 02-18-2010, 10:54 PM
Lithium78 Re: SumIf across columns 02-18-2010, 10:57 PM
teylyn Re: SumIf across columns 02-18-2010, 11:00 PM
Lithium78 Re: SumIf across columns 02-18-2010, 11:02 PM
DonkeyOte Re: SumIf across columns 02-19-2010, 03:35 AM
teylyn Re: SumIf across columns 02-19-2010, 04:01 AM
  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: SumIf across columns

    yup.

    =IF(ISNA(MATCH($A2,$D:$D,0)),0,INDEX(E:E,MATCH($A2,$D:$D,0)))+IF(ISNA(MATCH($A2,$G:$G,0)),0,INDEX(H:H,MATCH($A2,$G:$G,0)))

  2. #2
    Registered User
    Join Date
    02-18-2010
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: SumIf across columns

    Wow.. you swim in some deep water teylyn... I just tried that in B2 and it returned #NAME?

    Am I missing something?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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