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
|