I have 2 columns(G & H). H has dates in the format 50121(ymmdd). I want
to add the values in the G column for Jan. In other words, all values
in H that start with 501 add the corresponding values in G. Then for
Feb(502), Mar(503) etc............How? TIA

Greg

something like
=sumproduct((left(H2:H22,3)="501")*g2:g22)

--
Don Guillett
SalesAid Software

"GregR" wrote in message
ups.com...
I have 2 columns(G & H). H has dates in the format 50121(ymmdd). I want
to add the values in the G column for Jan. In other words, all values
in H that start with 501 add the corresponding values in G. Then for
Feb(502), Mar(503) etc............How? TIA

Greg