help with criteria sum

[sotiris_s]

i have two collums A1:A70 and B1:B70 i want the total sum of the multiply of
A1*B1 etc.. if the B1 etc.. cell is less than <3,5 I can calculate this by
doing on each row an if argument and then a sum of that row.... is there a
way that i can do it in a single cell?

Thank you very much ...

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(($B$1:$B$17=$B1)*($A$1:$A$17)*($B$1:$B$17))
or
=SUMPRODUCT(--($B$1:$B$17=$B1),$A$1:$A$17,$B$1:$B$17)

 

[sotiris_s]

It seams that it is working! thank you! i alter the first formula to look
something like this
=SUMPRODUCT(($B$1:$B$17<3,5)*($A$1:$A$17)*($B$1:$B$17))
this is the goal thank you very much it help me alot!