How to implement something like the SUMPRODUCT function in Excel?

V

Vyacheslav Grachunov2015-12-01 21:22:18

excel

Vyacheslav Grachunov, 2015-12-01 21:22:18

It is necessary that the values from the first column are multiplied by the values from the second column and added row by row, provided that the value in the third column is greater than zero. Is it possible to do it using Excel functions without VBA?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vyacheslav Grachunov, 2015-12-01
@Qwentor

Figured it out myself:
=SUMPRODUCT(--($J$3:$J$15>0),($C$3:$C15*$D$3:$D15))