SUMPRODUCT or SUMIF with Arrays
Does anyone know of a streamlined way of SUMPRODUCT or SUMIF with an array? Basically want to say if not in this list of multiple criteria then sum. See screenshot.
=+SUM($O3:$Q3)+SUMPRODUCT(--(($D$2:$L$2<>$O$2)*$D3:$L3)) works but want to take that $0$2 and make it multiple criteria without having to add additional SUMPRODUCT's for c_prob and d_prob
