Maybe
=SUMPRODUCT( (Data!$A$2:$A$1376 = 'Monthly Summary'!$A5) * (LEFT(Data!$B$2:$B$1376, 2) = 'Monthly Summary'!$F$2) * Data!$D$2:$D$1376)
Maybe
=SUMPRODUCT( (Data!$A$2:$A$1376 = 'Monthly Summary'!$A5) * (LEFT(Data!$B$2:$B$1376, 2) = 'Monthly Summary'!$F$2) * Data!$D$2:$D$1376)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks