=ROUND(SUMIF

Bruce678
Bruce678
edited 12/09/19 in Formulas and Functions

Hi 

=ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0)

The above is my formula.

It says, "IF the value in the Pareto Category column is the same as the value in the cell Predecessors21, then count all of the values in the Actual (MHrs) column".

However, I need the formula to say, "IF the value in the Pareto Category column is the same as the value in the cell Predecessors21, AND the value in a different column is the same as the value in a different cell, THEN count all of the values in the Actual (MHrs) column".

I only want to count all of the values in the Actual (MHrs) column depending on two scenarios (rather than just one scenario which I have now). 

Is this possible?

Hope that makes sense - any help would be greatly appreciated!

Cheers

Bruce

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!