Sum a range based on a column

  • Thread starter Thread starter Metro
  • Start date Start date
M

Metro

In column A I have subaccount numbers which may repeat. In columns B thru F,
there are amounts that I need to sum if they meet the specific criteria of
what is in column A. How do I sum B:F if column A is 74503? Thanks in advance.

A B C D E F
74503 10 2 1 0 5
73000 5 10 12 3 4
74503 1 2 3 4 5
76025 5 2 10 5 4
 
Back
Top