View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default 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