Thread: Sum if
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Sum if

I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!

SUM.IF($B$2:$B$265;<A2;$C$2:$C$265)

Thanks alot!