Summing product from 3 columns

[makinmomb]

The products are not in same line vertical , if they were I would
use a + b + c maybe

How do I sum this with the simplest formula , formula on L2

[PeteABC123]

Place in L2 and copy down:

Please Login or Register  to view this content.

Pete

[daddylonglegs]

A single SUMIF should be sufficient, i.e..

=SUMIF(A:G,K2,C:I)

[PeteABC123]

Nicer & cleaner.

A single SUMIF should be sufficient, i.e..

=SUMIF(A:G,K2,C:I)

[makinmomb]

Very clean indeed I agree

[makinmomb]

Thank you daddylonglegs , not only clean , small formula and powerful