Thread: sumif Question
View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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