SUMPRODUCT or SUMIF with Arrays
16:23 08 May 2025

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

enter image description here

excel excel-formula sumifs sumproduct