Sum a range based on a column
 

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

Sum a range based on a column
 

Try
=SUMPRODUCT((A1:A4=74503)*B1:F4)


"Metro" wrote:

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

Sum a range based on a column
 

Works perfectly. Thanks!

"Jackpot" wrote:

Try
=SUMPRODUCT((A1:A4=74503)*B1:F4)


"Metro" wrote:

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