Is this what you want for K11
=SUMPRODUCT(--($C$2:$C$1404>=J10),--($C$2:$C$1404<=J11),--($D$2:$D$1404 ="0100"), $E$2:$E$1404)
Is this what you want for K11
=SUMPRODUCT(--($C$2:$C$1404>=J10),--($C$2:$C$1404<=J11),--($D$2:$D$1404 ="0100"), $E$2:$E$1404)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks