Simple SumIf Not Working
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)
The ACTUAL formula I am using is: =SUMIF(FabricColor:FabricColor, FabricColor@row, Balance:Balance)
Help Article Resources
Check out the Formula Handbook template!