View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tigermoth tigermoth is offline
external usenet poster
 
Posts: 13
Default Formula for addition

If I have the followings table
A B
1 Code Amt
2 501 70
3 500 85
4 501 75
5 502 50
6 500 55
7 501 10
8
How do I set the formula to add the total amount for code 501in say cell B8?

Thanks