I need an excel sumif(s) formula that sums one column based on multiple conditions being met from three different columns. The problem I'm having is that the the formula is not picking up the four different names/conditions for my 3rd columns criteria. It seems to only pick one of the 4 names from my 3rd column.
=SUM(SUMIFS(Equip176[FY19 Amount],Equip176[Approved],{"New Request","","Pending"},Equip176[Purchased Yes/NO],{"";"No"},Equip176[Type],{"Jack","Admin-Tool","Lift","Cable"}))
So I'm summing Equipment amount based on Conditions from 3 Columns. The formula picks up the conditions from the first 2 columns but does not pick up the 3rd columns conditions. It seems to only pick one condition from the 3rd column. I need the formula to find 4 specific types of equipment from the 3rd column. Jack, Admin-Tool, Lift, and Cables. For some reason when i switch between , or ; it will still only pick one equipment type.
There are many different equipment types but i only want it to sum if the equipment name matches any of the four names listed above.....and of course meets the first two conditions.
Bookmarks