sumif Question
 

I have two column of data like:

A B
A45 $345.68
A35 $23.96
G38 $457.98
A13 $670.01
G68 $43.82

How may I sum the Column B data only if the corresponding column A data is
started by G?

Thanks.

Jason

Try...

=SUMPRODUCT(--(LEFT(A1:A5)="G"),B1:B5)

Hope this helps!

In article ,
"Jason" wrote:

I have two column of data like:

A B
A45 $345.68
A35 $23.96
G38 $457.98
A13 $670.01
G68 $43.82

How may I sum the Column B data only if the corresponding column A data is
started by G?

Thanks.

Jason

=SUMPRODUCT(--(LEFT(A1:A100,1)="G"),B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jason" wrote in message
...
I have two column of data like:

A B
A45 $345.68
A35 $23.96
G38 $457.98
A13 $670.01
G68 $43.82

How may I sum the Column B data only if the corresponding column A data is
started by G?

Thanks.

Jason

=SUMIF(A:A,"G*",B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have two column of data like:

A B
A45 $345.68
A35 $23.96
G38 $457.98
A13 $670.01
G68 $43.82

How may I sum the Column B data only if the
corresponding column A data is
started by G?

Thanks.

Jason
.

Works beautifully. Thanks a lot.

Jason

"Jason Morin" wrote:

=SUMIF(A:A,"G*",B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have two column of data like:

A B
A45 $345.68
A35 $23.96
G38 $457.98
A13 $670.01
G68 $43.82

How may I sum the Column B data only if the
corresponding column A data is
started by G?

Thanks.

Jason
.