ExcelBanter - help with sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help with sumproduct (https://www.excelbanter.com/excel-worksheet-functions/252491-help-sumproduct.html)

tleehh

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

T. Valko

help with sumproduct

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.

All times are GMT +1. The time now is 04:18 AM.