Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tleehh tleehh is offline
external usenet poster
 
Posts: 21
Default sumproduct

using this formula
=SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),M ONTH(TODAY())+0,1),"yyyymm")))
when column E is mark with "X", not to add the values in column H.