• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

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
0
Ladkisson
Asked:
Ladkisson
  • 2
  • 2
1 Solution
 
nutschCommented:
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"))
0
 
Shanan212Commented:
=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?
0
 
LadkissonAuthor 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
0
 
Shanan212Commented:
See attached

It seems you only have numbers 700 and 1307
Sumif.xlsx
0
 
LadkissonAuthor Commented:
well I have more data....that was just a sample but your formula worked. Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now