Simple SumIf Not Working

Options

I am attempting a simple sumif function and for some reason it constantly reads "INVALID." Below is a similar premise to eliminate wordiness.


I want the formula to look at the PRODUCT column and sum all the PRICE rows that contain the same PRODUCT, (i.e add all the prices of toys sold.) I am wanting this formula to be included on each row, hence the @row. The formula I am using is:

=SUMIF(Product:Product, Product@Row, Price:Price)

Product Price

TOY 12.00

TOY 13.00

Coat 15.00


The ACTUAL formula I am using is: =SUMIF(FabricColor:FabricColor, FabricColor@row, Balance:Balance)


Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!