Sumproduct problem
 

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

Sumproduct problem
 

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

Sumproduct problem
 

glad to help


--
Don Guillett
SalesAid Software

"GregR" wrote in message
ups.com...
Don, thank you very much. I had left the quotes off 501 and thus
wouldn't work. Back in the ball game now..............

Greg