Count Ifs for Multiple IF fields


I'm trying to write a formula that calculates the remaining items in an inventory category and within a certain date range. This count ifs would subtract from a fixed number everytime we restock inventory.

The inventory total on 8/22 for item #2 was 45. My team creates a new row everytime an item is distributed at our clinic and to whom. I want a formula to calculate how many of item #2 we have left in inventory since inventory was last counted on 8/22.

45 - (countif Date of CM is after 8/22/23 and the item number is 2) = ??

Thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!