Ladkisson

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

=SUMIF($B$3:$B$1423,$A1430

Thanks

`=SUMIFS(D$3:D$1423,$B$3:$B$1423,$A1430,A$3:A$1423,"control")`

Note that this portion doesn't look right

$A1430

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

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

Sumif.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

well I have more data....that was just a sample but your formula worked. Thank you!

=SUMIFS(D$3:D$1423,$B$3:$B

if you're on excel 2003 or before

=SUMPRODUCT(D$3:D$1423*($B