Sumif formula

Ladkisson
Ladkisson used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008

Commented:
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?

Author

Commented:
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
See attached

It seems you only have numbers 700 and 1307
Sumif.xlsx

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial