=SUMPRODUCT(IF(MONTH(A1:A10)=1,B1:B10))
=SUM(
IF(ISNUMBER($A$2:$A$500),
IF($A$2:$A$500-DAY($A$2:$A$500)+1=E2,
$B$2:$B$500)))
Hi,
using SUMIF, the comparison column contains dates in mm/dd/yyyy format.
I want to use the month from that column as the SUMIF criteria.
I tinkered with the MONTH() function to no avail.
Any ideas how to do it?
Thanks!