Trying to do a SUMIF formula - Help!

Kelly Reeves

I've been trying all kinds of formulas and can't get this to work right. I'm trying to do a formula with the below that says IF Approved? column = "Yes" then SUM the range of cells (CSM PM + DEV / BA + Arch/Engin + UIUX +QA)

Paul Newcome

Try something like this...

=IF([Approved?]@row = "Yes", SUM([CSM PM]@ow:QA@row))

Paul Newcome

Try something like this...

=IF([Approved?]@row = "Yes", SUM([CSM PM]@ow:QA@row))

Kelly Reeves

Thank you Paul! That worked!!! I feel like I tried everything except that! :)

Paul Newcome

Happy to help! 👍️