LinkBack URL
About LinkBacks
afriedman 
Hi Aaron,
If I understand correctly, the formula you want in I4 would be:
=SUMPRODUCT(($B$4:$B$11=$H4)*($C$4:$E$11>=1)*($C$4:$E$11<=5))
Hi Aaron,
If I understand correctly, the formula you want in I4 would be:
=SUMPRODUCT(($B$4:$B$11=$H4)*($C$4:$E$11>=1)*($C$4:$E$11<=5))
Yes, perfect! but I noticed you removed the (--)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks