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.
Bookmarks