Tom’s Tutorials For Excel: Horizontal SUMPRODUCT
Just a quick example of the SUMPRODUCT
function being utilized for data arranged horizontally across a row, instead of the more usually-seen columnar arrangement.
The formula in cell B12 is =SUMPRODUCT((A7:L7=B10)*(A8:L8>=B11))
The formula in cell B23 is =SUMPRODUCT((A18:L18=B21)*(A19:L19=B22))
Leave a Reply