Summing columns based on meeting multiple criteria

[Muckles93]

So I want find the total amount of refrigerant, by type and month. I'm attempting to display the amount of refrigerant by type (ex: 15 pounds of R-22, 25 pounds of R-23, etc.) on a per month basis. Link to a picture of the Excel file I'm attempting to set up: Imgur: The most awesome images on the Internet. I quickly compressed it into this so ignore the poor formatting of the last column (it's meant to be a total for the entire month, not each day). I tried putting this formula in the cell that is highlighted: =SUM(IF(AND(MONTH('Midsize Appliance Disposal'!$B$10:$B$1000)=6,'Midsize Appliance Disposal'!$D$10:$D$1000="R-22"),'Midsize Appliance Disposal'!$D$10:$D$1000,0),0). But all it gave me was "0", instead of "15". Any help would be appreciated, thanks.

 

[yky]

Have a look at SUMIFS function.

 

[Muckles93]

Thanks for the advice! That worked.