“=SUMPRODUCT(IF($C11:$C34=$C$14, D11:D34,0),IF($C13:$C36=$C$14, D11:D34,0))” Here’s my function. It returns a ‘#VALUE!’ error, but actually returns a value if I look in the function wizard window. Any thoughts?
I think you have to enter those like you would an array. Try entering it and hitting Ctrl+Shift+Enter I’m not sure, though. Here’s a link that I found really useful for explaining how to do multiconditional sumif functions in Excel: http://www.mrexcel.com/archive/Dates/27824.html