C
Chuck
hi guys,
i have a worksheet that looks at purchases i have made and the
sumproduct calculation should look at the date of invoice (tabs
01-13). however, i can only get the sumproduct to just look at the
month, but i also need the year
here is my formula
=SUMPRODUCT(--(MONTH(POSummary!$I$3:$I$171)=MONTH(I$8)),--(POSummary!$C
$3:$C$171=$B78),(POSummary!$G$3:$G$171))+SUMPRODUCT(--
(MONTH(Contractors!$F$3:$F$9999)=MONTH(I$8)),--(Contractors!$E$3:$E
$9999)*1)
can anyone advise how to accomplish this? i tried doing
=SUMPRODUCT(--(MONTH(POSummary!$I$3:$I$171)=MONTH(I$8)),--
(YEAR(POSummary!$I$3:$I$171)=YEAR(I$8)),--(POSummary!$C$3:$C$171=$B78),
(POSummary!$G$3:$G$171))+SUMPRODUCT(--(MONTH(Contractors!$F$3:$F
$9999)=MONTH(I$8)),--(Contractors!$E$3:$E$9999)*1)
but i keep getting an error
cheers
chuck
i have a worksheet that looks at purchases i have made and the
sumproduct calculation should look at the date of invoice (tabs
01-13). however, i can only get the sumproduct to just look at the
month, but i also need the year
here is my formula
=SUMPRODUCT(--(MONTH(POSummary!$I$3:$I$171)=MONTH(I$8)),--(POSummary!$C
$3:$C$171=$B78),(POSummary!$G$3:$G$171))+SUMPRODUCT(--
(MONTH(Contractors!$F$3:$F$9999)=MONTH(I$8)),--(Contractors!$E$3:$E
$9999)*1)
can anyone advise how to accomplish this? i tried doing
=SUMPRODUCT(--(MONTH(POSummary!$I$3:$I$171)=MONTH(I$8)),--
(YEAR(POSummary!$I$3:$I$171)=YEAR(I$8)),--(POSummary!$C$3:$C$171=$B78),
(POSummary!$G$3:$G$171))+SUMPRODUCT(--(MONTH(Contractors!$F$3:$F
$9999)=MONTH(I$8)),--(Contractors!$E$3:$E$9999)*1)
but i keep getting an error
cheers
chuck