+ Reply to Thread
Results 1 to 2 of 2

Dragging a function across columns, one constant

  1. #1
    Registered User
    Join Date
    04-01-2010
    Location
    St Paul, MN
    MS-Off Ver
    Excel 2003
    Posts
    1

    Dragging a function across columns, one constant

    Hey everyone! I've been searching online for a while and I just can't seem to find the correct answer.

    For work, I'm trying to figure out how to drag the SUMIF function across 4-6 columns. I am trying to total the number of people who do a search online using specific key terms.

    I have selected the terms I want to evaluate by putting a column next to the name (column A) and placing a "1" in the appropriate row/column if that source was used. There is then a corresponding number of searches for each key term.

    Basically, I want to be able to keep the "1's" in Column B a constant but be able to change whether I'm pulling the numbers from Column C, D, E, F and so on (which could be considered months).

    I have a "Total" row for the findings of the functions.

    I may have confused a lot of you, and I'm sorry. This is just really frustrating me and I'm tired of filling out the SUMIF function over and over again. Help!!??

    I attempted to create a small sample spreadsheet, similar to what I'm working with.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Dragging a function across columns, one constant

    Hi,

    Why not posting your worksheet ... it would be more explicit than a picture ...

+ 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