Sum a range based on a column

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top