Results 1 to 7 of 7

SUMIF with Horizontal sum range

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    Minneapoils
    MS-Off Ver
    Excel 2010
    Posts
    4

    SUMIF with Horizontal sum range

    Greetings,

    I'm trying to use the sumif function in excel 2010 to find a row in a worksheet then only sum certain columns in the row. Below is sample date and the formula I'm currently using.

    Example data:
    Column: A B C D....
    Row 1: Account#, period 1, period 2, period 3....
    Row 2: 105320410, 10, 20, 30...

    =SUMIF(A1:D2,105230410,C1:D2)

    The result is only the first cell in the range, or 20, instead of the desired result of 50.

    Thanks in advance for your help.
    Last edited by mennojim; 09-22-2010 at 05:09 PM.

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