please help with FORMULAS

[Guest]

I need an formula for a matrix I am building
A B C
1 600 45
2 900 55
3 650 50
4 750 60

If B is greater or = to 600 but less than or = 800 add C
ie = the answer would be 165

thanks

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(B1:B4<=800),--(B1:B4>=600),C1:C4)

 

[Guest]

Sub tst()
Do Until ActiveCell = ""
If ActiveCell.Value >= 600 And ActiveCell.Value <= 800 Then
totl = totl + ActiveCell.Offset(0, 1)
ActiveCell.Offset(1, 0).Activate
Else
ActiveCell.Offset(1, 0).Activate
End If
Loop
MsgBox totl

End Sub

HTH

Devin