SUMIFS between specific cells


I want to sum the values in a column only if the values are between cells 2 to 729 and only if "Nina Gallagher" is in the "Who" column

I've gotten this far --

=SUMIFS([10/5/20]:[10/5/20], Who:Who, ="Nina Gallagher")

When I try this, I get #INCORRECT ARGUMENT --

=SUMIFS([10/5/20]2:[10/5/20]729, Who:Who, ="Nina Gallagher")'

The row in pink in the photo below is where the formulas are. I'd appreciate any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!