Thread: Sum of value if column contain specific value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crapit crapit is offline
external usenet poster
  
Posts: 75
Default Sum of value if column contain specific value
A B

1 AR 21.40
2 AL 400.00
3 AL 100.00
4 AR 8.90
5 AR 16.90
6 AR 42.00
7 PS 30.00
8 PS 40.00



How to add up column "B" value if the corresponding value in column "A"
equal AR ???


Reply With QuoteReply With Quote