Link to home
Start Free TrialLog in
Avatar of Ladkisson
LadkissonFlag for United States of America

asked on

Sumif formula

Hi, this is my current formula. Column A3:A1423 has values either "test" or "control". I need to keep the existing formula plus the "control" criteria. So if any of the cells in column A have the word "control" I need to proceed with my sumif formula.

Avatar of nutsch
Flag of United States of America image

if you're on excel 2007 or after:

if you're on excel 2003 or before

Open in new window

Note that this portion doesn't look right


^ Above will change if you drag down the formula. Whats your criteria for B column?
Avatar of Ladkisson


The suggested formula did not work. Please refer to the attached file. I need to incorporate columns A & B and pull the totals from column C for the highlighted data. Thank you!
Avatar of Shanan212
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
well I have more data....that was just a sample but your formula worked. Thank you!