New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
Home
Microsoft Office How to Use SUMIFS or SUMPRODUCT to get invoice info in Excel
![](https://assets.content.technologyadvice.com/thumbnail_Logos_Wonder_How_To_color_light_21e00e7b4a.webp)
May 3, 2010 11:34 PM
![Stock management spreadsheet displaying quantities and totals.](https://assets.content.technologyadvice.com/634753583031763029_0351ca5bcb.webp)
Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.
Comments
Be the first, drop a comment!