help with sumproduct

  • Thread starter Thread starter tleehh
  • Start date Start date
T

tleehh

using this formula
=SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,1),"yyyymm")))
when column E is mark with "X", i want the values in column H to be not added.
 
Back
Top