Sum for a Coloumn based on Multiple column categories.

Miguel P

I have this meta data sheet that shows all the information from a form being submitted, and im trying to gather sums of specific resources based on their qualifiers into another sheet thats easier to others to read.

Example would be I have a resource that has multiple configurations and im trying to separate those out based on what has been input form a form. I want to sum the column of 36x96 SS for the rows that show Wall Mounted and Internal.

Here is the Formula I thought would work based off a previous formula I was using just for one criteria.
=SUMIF({{Nashua Inventory Sheet Meta Data Range 94}, "Wall Mounted",{Nashua Inventory Sheet Meta Data Range 86}'"Internal"}, {Nashua Inventory Sheet Meta Data Range 93})

Adam Murphy

Hi @Miguel P ,

The SUMIFS formula allows multiple criteria. Try this:

=SUMIFS({Nashua Inventory Sheet Meta Data Range 94 - This should be the 36x96 SS column}, {Nashua Inventory Sheet Meta Data Range 86 - This should be the Mounting Type column}, "Wall Mounted",{Nashua Inventory Sheet Meta Data Range 93 - This should be the Power Type column}, "Internal")

I also HIGHLY recommend that you give your cross-sheet references meaningful names, it will help with troubleshooting, etc down the road.

Hope this helps!