see your other post

--
Biff
Microsoft Excel MVP


"tleehh" wrote in message
...
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", i want the values in column H to be not
added.