Thread: [Solved] Formula Help Needed
View Single Post
 
Old 02-05-2018, 02:45 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
What about:

=SUMPRODUCT(ISNUMBER(Risks!Q5:Q20)*(Risks!$Q5:$Q20 >=3)*(Risks!$Q5:$Q20<=4)*(Risks!$K5:$K20>=(--("1/1/18")))*(Risks!$K5:$K20<=--("31/1/18")))
Reply With Quote