Another possibility might be
![]()
=SUMPRODUCT(--($B$2:$B$300=$H5)+--($C$2:$C$300=$H5),--($A$2:$A$300>=$I$2),--($A$2:$A$300<=$I$3))
Another possibility might be
![]()
=SUMPRODUCT(--($B$2:$B$300=$H5)+--($C$2:$C$300=$H5),--($A$2:$A$300>=$I$2),--($A$2:$A$300<=$I$3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks