Matt Pinkston
asked on
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'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, forgot a double quote after Commit...
try:
=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit",'all deals'!K:K,"Test")
try:
=SUMIFS('all deals'!H:H,'all deals'!E:E,"Commit",'all deals'!K:K,"Test")
ASKER
it was missing a "
ASKER