=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
.
|