Prev: Excel Text Formula
Next: Formatting Dates from Text to Numbers
From: Metro on 4 Jun 2010 09:04
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

From: Jackpot on 4 Jun 2010 09:10
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
>
From: Metro on 4 Jun 2010 09:21
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
> >
 | 
Pages: 1
Prev: Excel Text Formula
Next: Formatting Dates from Text to Numbers