SUMIFS with Multiple Criteria
My ultimate goal is to be able to get a sum of the inventory per item, by month. For example, I would like a formula to return the amount of Control Panels there are in June 2020. Based on the screenshot below, the result I should receive is "2" as is only one project in June 2020 and the project has 2 Control Panels listed.
This is the formula that I am using but unfortunately is returning 0:
=SUMIFS([Project Name]:[Project Name], FDOB:FDOB, IFERROR(MONTH(@cell), 0) = 5, FDOB:FDOB, "Control Panel")
If anyone can provide assistance on this, that will be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!