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
|