Thread: Automatic Summations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fusion_Guy Fusion_Guy is offline
external usenet poster
  
Posts: 4
Default Automatic Summations
A B C E
1 lunch 5 lunch 10
2 food 6
3 lunch 5


for col E, row 1 your formula is:

=SUMIF(A1:B3,D1,B1:B3)

Reply With QuoteReply With Quote