Thread
:
Sum if
View Single Post
#
1
Posted to microsoft.public.excel.programming
Arne Hegefors
external usenet poster
Posts: 244
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!
Reply With Quote
Arne Hegefors
View Public Profile
Find all posts by Arne Hegefors