Need a Formula to conditionally sum data

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'
Matt PinkstonAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Try:

=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit,'all deals'!K:K,"Test")
0
 
Matt PinkstonAuthor Commented:
got an error trying that formula
0
 
NBVCCommented:
Sorry, forgot a double quote after Commit...

try:

=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit",'all deals'!K:K,"Test")
0
 
Matt PinkstonAuthor Commented:
it was missing a "
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.

All Courses

From novice to tech pro — start learning today.