Tom’s Tutorials For Excel: Horizontal SUMPRODUCT

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))

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published.

*