[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Need a Formula to conditionally sum data

Posted on 2014-02-04
4
Medium Priority
?
171 Views
Last Modified: 2014-02-04
in my summary tab I want to pull in the sum of column H when column E = Commit and Column K = Test from tab 'all deals'
0
Comment
Question by:Matt Pinkston
[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
4 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39833057
Try:

=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit,'all deals'!K:K,"Test")
0
 

Author Comment

by:Matt Pinkston
ID: 39833074
got an error trying that formula
0
 
LVL 23

Expert Comment

by:NBVC
ID: 39833092
Sorry, forgot a double quote after Commit...

try:

=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit",'all deals'!K:K,"Test")
0
 

Author Closing Comment

by:Matt Pinkston
ID: 39833122
it was missing a "
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

650 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