Sumif formula

Posted on 2012-12-27
Medium Priority
Last Modified: 2012-12-27
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.

Question by:Ladkisson
  • 2
  • 2
LVL 39

Expert Comment

ID: 38724073
if you're on excel 2007 or after:

if you're on excel 2003 or before
LVL 13

Expert Comment

ID: 38724087

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?

Author Comment

ID: 38724128
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!
LVL 13

Accepted Solution

Shanan212 earned 1200 total points
ID: 38724180
See attached

It seems you only have numbers 700 and 1307

Author Closing Comment

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

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.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question