PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
1 day, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sumif formula
Posted on 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.
=SUMIF($B$3:$B$1423,$A1430
Thanks
=SUMIF($B$3:$B$1423,$A1430
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
if you're on excel 2007 or after:
=SUMIFS(D$3:D$1423,$B$3:$B
if you're on excel 2003 or before
=SUMPRODUCT(D$3:D$1423*($B
=SUMIFS(D$3:D$1423,$B$3:$B
if you're on excel 2003 or before
=SUMPRODUCT(D$3:D$1423*($B
=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?
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Intro
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses
Course of the Month1 day, 18 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.