You can add those criteria in like this:
=SUMPRODUCT((E2:E100>0.5)*(F2:F100>0.5)*(X2:X100=B2)*(Y2:Y100=B13)*(Z2:Z100<AA2:AA100))
You can add those criteria in like this:
=SUMPRODUCT((E2:E100>0.5)*(F2:F100>0.5)*(X2:X100=B2)*(Y2:Y100=B13)*(Z2:Z100<AA2:AA100))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks