View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HeatherJ HeatherJ is offline
external usenet poster
 
Posts: 24
Default Need to find matching criteria in 1 column, then add amounts in a

Hi,
Trying to match criteria in one column and then add amounts that are in a
second column. Need to find all in column A that match, then add amounts in
column B for matching criteria. Thoughts? Thinking maybe better to try in
Access?
A B
1 8268001100 144.78
2 8268001100 12133.09
3 8266012100 640.84
4 8266012100 404.11
5 8206011600 122.14
6 8206011600 1787.00