Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...B3:H3=B17)*(...B4:H15))

How to sum every nth column in excel.

We will use SUMPRODUCT () to check in header row for the given column value and the formula will sum up the values from the corresponding column.


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

SUMPRODUCT(array1, [array2], [array3], ...)

Lets chat on this