Forum Discussion
Solved
SUMIF Problem
I’m trying to use excel to keep an accurate count of inventory for our small church bookstore (non-profit). I decided to use UPC codes on my spreadsheet so that when I scan an item that is being sold...
The message you're getting indicates there are two different formulas in the table column. One of the benefits to using a table is having the formula auto-fill to the bottom. To resolve it, clear the entire column and re-enter the formula and it will fill to the bottom.
Edit - it appears that column was formatted as text and not calculating. Please see the fixed copy attached.
The formula is close but only referring to 1 value in table 6. Here's a before/after. The capture on the right is the correction to be made:
=SUMIF(Table6[UPC Code],[@[UPC Code]],Table6[Qty])+[@[Beg. Stock]]