Sumif WTheck?

JH@HL ✭✭
edited 12/09/19 in Formulas and Functions

Hello - I am trying to draft a formula to sum the column 9 but only when column 3 is "John Smith" and when column 11 is not equal to "complete." 

I got this far, but can't figure this out: =SUMIF([Column9]:[Column9],Column3; column3, @cell="John Smith")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!