I'm trying to create a formula to sum a range of numbers if two conditions
are true.

Please help.

Is there a way to do the following in a cell using a SUMIF
IF (A1:A100,"category") AND (B1:B100, "unplanned") then add C1:C100

Thank you.