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.
 
=SUMIF($B$3:$B$1423,$A1430,D$3:D$1423)

Thanks
Avatar of nutsch
nutsch
Flag of United States of America image

if you're on excel 2007 or after:
=SUMIFS(D$3:D$1423,$B$3:$B$1423,$A1430,$A$3:$A$1423,"control")

if you're on excel 2003 or before
=SUMPRODUCT(D$3:D$1423*($B$3:$B$1423=$A1430)*($A$3:$A$1423="control"))
=SUMIFS(D$3:D$1423,$B$3:$B$1423,$A1430,A$3:A$1423,"control")

Open in new window


Note that this portion doesn't look right

$A1430

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

ASKER

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!
Sumif.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shanan212
Shanan212
Flag of Canada image

Link to home
membership
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!