Thread
:
Sum up values from adjacent column
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
Sum up values from adjacent column
Enter 2200 in C1 then in D1 enter this formula:
=SUMIF(A1:A9,C1,B1:B9)
This enables you to change the criteria in C1 without having to change
the formula - maybe relevant to your other post.
Hope this helps.
Pete
Reply With Quote