Hello. I am horrible with array formulas. Can someone please explain each piece of this array formula and why it needs to be an array?
Thanks.

=SUM(IF(B5:B12="Jim",IF(ISNA(MATCH(C5:C12,{"dog","cat"},0)),D5:D12)))+SUM(IF(B5:B12="Jim",IF(C5:C12={"dog","cat"},-D5:D12)))