please help with FORMULAS
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
|