View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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