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

One way:

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


In article ,
boogie wrote:

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

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

"boogie" wrote:

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