Thread
:
sumproduct
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
tleehh
external usenet poster
Posts: 21
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.
Reply With Quote
tleehh
View Public Profile
Find all posts by tleehh