PDA

View Full Version : Counting Consecutive numbers > 100 in a column by multiple criteria



Loss1003
08-09-2018, 07:07 AM
Need help counting consecutive numbers > 100 in a column by multiple criteria.

The criteria:
Column A = Data!E$2
Column C = Data!E$3
Column D > 100





















http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUcAAADtCAIAAACj2yAAAAAXIklEQVR4nO2d3ZXq OgyF3UuKSS2UQiUUQh3U4vugi5ZGdkxiKUTi7O/hrDkMYYTsHf/uuNQklFKuDkETMKS8IJkuUBrTpDJgqQcMKS9IpgtQtZWAIeUFyXQBqrYSMKS8IJkuQNVWAoaUFy TTBajaSsCQ8oJkugBVWwkYUl6QTBegaisBQ8oLkukCVG0lYEh5QTJdgKqtBAwpL0imC1C1lYAh5 QXJdAGqthIwpLwgmS5A1VYChpQXJNMFqNpKwJDygmS6AFVbCRhSXpBMF6BqKwFDyguS6QJUbSVg SHlBMl2Aqq0EDCkvSKYLULWVgCHlBcl0Aaq2EjCkvCCZLkDVVgKGlBck0wWo2krAkPKCZLoAVVs JGFJekEwXTlH16/UqpZRSXq X7ycbS50DY5ZluTakL3C73fj73m63q8MZETmZMo0uNec8TlH14/Ggb36/330/2UXVXLPVfy8J6WzWdeUIXb7vqUROJqmaG6plWcIK xRVr u6LAv96/vJvqqmD1zX9cKQTuX5fJZSHo/H1YHsJXIylaqp6Xo n9dG1cVf1aSc /1 v9/dv7avqqnSGzsUkSsiFYH7OOg8IidTqZrr bVRdfFXNYv5jP4extWHUBUxPomS W pWo433Dvh7j3wZVmMnxm5IqKtduTfVTX1aRWOnXB3Vdtbs8gVkcZ GFe78O Oq mb81d174Sf0VYbexORK2LtzYEbZwdPJXIy/9058Hakau/iqs 3XN6Oq 0d1MgVkcB6tQv/ nr1eQQs9YAh5QXJdAGqthIwpLwgmS5A1VYChpQXJNMFqNpKwJDygmS68L qAQC/REVbbSFgSHlBMl2Aqq0EDCkv5yWT1u3lKiavudIPEtq3Q6 3C9TtViu5F0WtnvLl7VXnbRyAqq0EDCkv5yWTtoLxBk 5H2lrPwmpmrWnVM0fJV1M9CveFND iq9ycRZtAVVbCRhSXk5NppQo6Y3b5IGqWZZbqqZPJiW3xgd RV11qtcdqrYSMKS8nJpM2QmXG2kHqiZh028HqmbptkJlg4266tQt lC1lYAh5eXUZLKQVDvZjqv59WVZuFX/qOpu86tULTnP7wVVWwkYUl5OTSabW1Q7OW6r69vdMNdWsydEXkX3kfP8XlC1lYAh5eXsZFLHW3a/6w5V83P4JsbV3XsB/XyePwSqthIwpLycnUzW5x43rnxdDrCPzoFTp0BdRXcWzIHXGlJCAUPKy9nJ5MVkOU3Vjqu5n8yq lq2rZb1azYGf9H2haisBQ8oLkukCVG0lYEh5QTJdgKqtBAwpL0imC1C1lYAh5QXJdAGqthIwpLw gmS5A1VYChpSXiWRuzUh3H2LdfV15p7qT24OraI1KRk7/latltBel3fXNK23y/VuR7weqthIwpLxMq5pXjNhfuWWKGnin1JOV5Ra0wVWsanU3karmxTMZiTqyarB37ShQtZWAIeXF rmqWyk5Vy83b1KLKN/Mrg6tI1cuy0H8pgHatmz5KrpN3W /2b00AVVsJGFJevq9q2SAvy6J643xAx AqUvXtdiMZr tK 0ZZ1XxrkB2BwXGlUPX1BAwpL 49cAk1jAPvVGnG2ErV3atI1fROPnxLqpo/Vp7 MXBibkW H6jaSsCQ8jKtagnJZk9brbxTbVvdbfnVVWzb5m728/lUzhA5OG9/HkQ4B1RtJWBIebG31YdeV96pdlzN7q7BVfweOSXGqua5NIZuHINnoUDV1xMwpLx8WdX1r3eqOwc uldy9ilVNNwW6nFTdHlcoO HtHHh7B5kDqrYSMKS8uKu67Zx/9E7J96v16u5VrGp5F1DPUeEPVw9F3L9efeiMR6jaSsCQ8oJkugBVWwkYUl6QTBegaisBQ8oLkuk CVG0lYEh5QTJdgKqtBAwpL0imC3tVTfNyco6eF99poq9dkSPot2pxv13E2/kU1T2lLv cXGyoYl1BPWVSxbAsy PxoK/8ce7xvIqoHm1XxQyqnDuVM6j0Ol/SbmzsllF9Z4aQf3G6pOb4gqo/erZaf1WbBKoYyo hdoOqh5B203sSZX9bLbenywl6teym4IxIeShRqf9 DHeMOpaB/jr/V 4NkO/h5QdatHg n7TvzyWkaXgNk C70tZ Q1Y7FUerahm28hJyAbW/4qv2l9QcX1P14Lyrrr q9vaNKFWXnsFL3ZrbO/UZHFA1vXt5n07CX3ugarmNTj0VvVtZd4Y7hj N/jrv72t9NlVs4uXPV3zcDHBqRVS5LX/b5IGqSZYDVaszJeRHyVemS2qO76taaXXLX9W s/ZU3Vop2yeEf4FjqqZaohq3gaq56qhHLu98zPpWuHuCfDwe/AOluK2s7e2GYubtQXv295xaEeWtXdaVsaq5gAaq5mxwGakvpW5/xP6SmuP7qlaZ7PqriI qprRzTaM/8YWWueWYqqs4/YBfacfV7VknSvntQOVQuGPYN8MlRLv2ZfVVAajRwe124364S0gWOIet46ftU8gbGc0OfFR1t/lVqp4oqTm puo2dRxA668iPqqahmxUbei/Wwd6nd16H1Z120pstdXtUybUNlr tP3Hc 8sdZIxG9l5/oMv57ZazXOUhmt74By8tAHVT201t8ByfLG/re4OVY6W1BxfU3XXfbXlryL2qJqzVLbb6rP7O/VUVctpVXWLkjVMjWz3hPsRbmHk3F7ZmASSARydKtsf0jR83ynb/UZGPQNAJmH/uHqrhT9UUnN8WdVd95VE3sX2qFp yNa4OreqVU9Dvk3WFe4R7Q/3IzwooCaI9 K3nYX6d6c fbv67oc7hmSB9ckt6h5V871sYg68e/89VFJzfFnVVbivxv6qulvVnKXuHDh9ZhpVqzZZeVPq36/XnVl1nJpS9 C64XRXAdxuNzlV5tt9sNBWhXZcLe9KHHnbA 2QvXTerV629kHL5/Klvvqo79qp6prL0uqpM5bROA/V7G3zELAkPKCZLoAVVsJGFJekEwXoGorAUPKC5LpQnkvuQMAfoeKttpCwJDygmS6AFVbCRhSXpB MFyZVzcskcrmFW3 1avJ8PuUr7Z6Qo G6cLvdXDZUDEJq 0VsMlHL 7Q0wlfJRZHH43H2jq44xFQ1r37J8ORK4YWxdZlRNW2xpp9vtxsfLyTPT1APZ R6SU4P/pyjK59eGeyacuYYq7pdmWQnmXxReuCoosgNJ1D1tdAzgKton2RDRdscroyvwdoD56 3risrmb8nr xLQ7nczDx31IgR2h ruuFqqY9w/QKWyz4KjqriX8LVV9LEZsU2a0kd 9GKyCrqlmZfD rfxvz2nztCG11rfVaVT fT04R3RClquk9vPEzWqU5j5iqXtdVtdVy CYbqiBYVc0VV9bgsarbXdlHw3XhO6qWUNnT16/vuxvd/vnF s4k70iHqiNAQyS5c/5nVS3Hzzvb6sfjIdvqo/U1naq32ur6vt TF7JVdX3PWUDV10JFI0/kqz/cVqvZJjmuVl1rWS/lr2RVPhSuC5ermrpzlLeuquvbnQtVX4hawaGWTFZj9YYIzKia7lhqbUa2z7INr01bbUnHL6m6Cs/jlqq/86yCOARUNT2Rlv/Ld2Run39kDlx5 mS9JFQtVH1I6dycC9eF74 rqXcjBczrgluqpjih6muRD0VSR1jOVeOzsc6WfZmwGQQuIJkuQNVWAoaUFyTTBajaSsCQ8oJkug BVWwkYUl6QTBcK/NUA/B4VbbWFgCHlBcl0Aaq2EjCkvCCZLkyqOrW/uhv8NIOQ2n4R/NVjYqpaHY5H8LOWo21Bqf gv7obvIWxquGvPkRMVRfhxFzfh43KTdCnnmcygbUHntFfzbjs4J1TNfzVXQKqut0H/nq9lLsjWgFZVZ3XX12nbistc6qGv7pLClVT2f2mZ4uvT qvrhuqm/iQwa8k8Fd/JKCqq4iKCuX5fMr2oD0f73JMqk7tr1bGsmnm2uoKf3WPmKrm2bLb7cbVRs6W/Y6qS2Z/dfE7sXVa1fBXt8RUtaSN0GUc58uMqlP7q7vBW5hWdYW/uiGgquWzUGierP7tZt7vd8fq5MKMqlP7q7vBW9g/ri7wV38ioKqr2GEha8v69/T5UJjG1d8nYKkHDCkvSKYLULWVgCHlBcl0Aaq2EjCkvCCZLkDVVgKGlBck04UCfzUAv0dFW20hY Eh5QTJdgKqtBAwpL0imC5OqTu2v5r1 LluCPoZE2wzVJRIOo 1H0ZbjIlawpfFDXhJt0 IcAVUtN03KTRmq8oTaYTaj6tT arklxuVB/x9DWpZFbbYrf/eZLMtCYZQNt4ncacxvrn/zPLGpPiDRVE2tl7QYy/up2gKYW9WS1P7qidtKyzgk2iGr7C5KvZyuLVXXWpdloc R90f1pweXZyGUqsvbudG1MHGTQH0xVcTXYlV1an 1i21rHBIdfawU2LbVFMZAltz3UxcW1z3tlxNK1YSsJDI8dbzWT6m65PRXU5fp7OeWyQkF2dtXg2 fOg3q9fQpSG7DcVB/tOTsTRFa1ujX/rKpT 6tVMNMMQuJpOaXSrTZ50FaTH5N6et03uHvRLiGyquu/0FaXzP7q6QBaBp/QjnvHPe2t10mx3JOnD2mfpuB1yueFBFe1bLrkzFn9AVWn9lfLDsKpTyOU35Tg9YKjqpbz3nI XN5YpQ04L8FVLdtnle30qk7tr66iY3zquFre1wkW3kDVChojqHzKV Sbs0u6hle1PMhaaTi9qi8kYKkHDCkvSKYLULWVgCHlBcl0Aaq2EjCkvCCZLhQ4MQH4PSraagsBQ 8oLkukCVG0lYEh5QTJdmFT1tBNTbbc6WoqOpS6PtrIw JC2X4STbscEVLXcXkVI32H9u1IbZHFxRtUWJ6ZkXdcL3R3ycFkLY1XjpNtDRFO1cmLWpviUBzGI y93aAz/qxGTmUuBV6nRjulDVOOm2SyhVl8aJSaagQdUNEr9V1RNOTELugjwarpH2GEoLc6rGSbddgqhC0t p1t462VT3zC7Gquhx3YlbDkb8upd4eWGdh/7gaJ91 JLWq47hrTKqecGISysV2NFwL3Lm4tq2uOOm2R15VT1fpM5hXdZlyYhLTDyGxl7pxEv5QSGNV46T blqSqXtc1jrWjft JWW2NpGOpX95W0xtw0q0ko6pLvGMxZ1RtdGJOD6prQlUrcNLtmHSqlovVRIQla ts2ZcJWOoBQ8oLkukCVG0lYEh5QTJdgKqtBAwpL0imC1C1lYAh5QXJdKHAXw3A71HRVlsIGFJek EwXoGorAUPKC5LpwqSqU/urZQz2LUGDkNp EfzVYwKqeuukW7VTiEi8Dzy7v7p9UreFsarhrz5ENFUrfzVXbLkRhauTZXuVL9YeeEZ/tW/VmVM1/NVdQqm6NP5q9dvauC 7Jf59rKpO56 mYmiHD9PMqRr 6i6hVE10Vc2Fog51cjk72Y5V1SWbv1r2EV6v13nnbFX4q4 TQtXUKnTvub g6oz askXzsSEv/oQKVTNrz8ej19rq0tOf7XkWlXDX92SSNXUMqlxte9E7DQzqk7tr5ZxysHtNNOqrvBXNwRXtaz23 Ix1J8avZUbV2f3VvF7topb94 oCf/UngqtaVnJ5onj74rVYZ8u TMBSDxhSXpBMF6BqKwFDyguS6QJUbSVgSHlBMl2Aqq0EDCkvSKYLBf5qAH6PirbaQsCQ8oJkugB VWwkYUl6QTBcmVZ3aX027aCb tGQ2n4R/NVjAqpa2qe5ELtbNuIwo rU/mq5xc9FMGNVw199iICqltzvdy/34alYe Dp/NVqj7qdOVXDX90lsqqp4FSBdnV OVZVp/NXUwfBseM0p2r4q7tEVjV3SyXtYCoCVlWXbP7qdV2/2QNvR1/wVw IrOr2Hh22aEyqzuivlkeHw18djbCq7pbCGuYYesW8qktOfzXphH6GvzoaYVXdbYe65RuBGVWn9l fLzj9PCliYVnWFv7ohrKr3nE0fhxlVZ/dX8wrkF2bLFPBXjwmr6kSD6oq9ZXYChpQXJNMFqNpKwJDygmS6AFVbCRhSXpBMF6BqKwFDyguS6 UKBvxqA36OirbYQMKS8IJkuQNVWAoaUFyTThUlV5/VXGwM4FFLbL4K/ekxAVctNk4Q6r6OKgg7i9JhRdWp/tTGAlrGq4a8 RDRVr3/Pr6694mMHhMsGZBesPfB0/mpjAC1zqoa/uksQVRClOb adiXKmqNOzwuCVdXp/NXGAFrmVA1/dZdQqibGO8CpqvOJ6EHMHlZVl2z amMALfvH1fBXfySjqrnm/0gPPKO/2hhAy1xbXeGv7hFEFZI9bfXgzZcwr qS019tDKBlWtXwV7ekU7Uy8yZWdWp/tTGAlmlVV/irG9Kpuoryale8rmJG1dn91b5 9/3j6gJ/9ScyqlrW/B ZLfsyAUs9YEh5QTJdgKqtBAwpL0imC1C1lYAh5QXJdAGqthIwpLwgmS4U KsB D0q2moLAUPKC5LpAlRtJWBIeUEyXZhUdV5/dRXPA3dZBx6E1PaL4K8eE1DVctOkPPmcN1byYYwl9Xp1an 13ADkcurtWNXwVx8imqqVv7r8NXK8Xi 1ezTx3jJJOn91kBN54K/uEkrVpfFXS9pnpNQw8VtVndFfHaGthr 6SxBVSLZULSs8kXsfuLo nb aN 66mDH3j6vhr/5IFlWrGk7EOfjWpOqM/mrZ87/f72efSg9/9SFSqLpbIo6OfTvzqi45/dUyNpxfHY34qqaRtnrPuq72CRpHZlSd2l9NbSP97PIouWlVV/irG4KruuuK9RrKOTKj6uz arnAaP 0/ePqAn/1JyKrWi5Wc2nKukREWLI2jau/T8BSDxhSXpBMF6BqKwFDyguS6QJUbSVgSHlBMl2Aqq0EDCkvSKYLBf5qAH6PirbaQsCQ8oJkugB VWwkYUl6QTBcmVZ3aX81rjC77gT6GRKerqUskHEbbj3o n7QRhVdBpfFDXhLEV2AkoKr3nF9NFJxfXS/yVysn5qmeLWJZFrXZrvzdq8D2tbKxh0HuUpReN/mxLnvaLyeaqvecX01Qc5VY1ZJ0/mq1D9zexI1DohuHsrso9XK6tlRda12WhT6HM9luvB1cnoVQqi47zq8mSAVBDtmq/6C/ pvujlrruq6v10v9obatptowkCVvyFUXxmkfXAilauLjiTz1Xfl/R9Ulm7 6HeQbP3DwCfJvSfOtGjzzXUa93ladNmlyH3IQc6 FjKrmduJHVJ3RX12FEugH46cNPkFNDXJV2GqTB201 TGpH959Q9dIl450qpaDuF9Qdcnpr5Z8wYmp/jvuaW 9Torlnjx9SJvVOM/imCadqvl5tUwEYc oOru/WhaJXQZbIbUT7LxecFTVcg5CzofLGys/9XL2e4QgnarH77yKGVVn91dzx/jU9eru0 rK 0mDW6pW0D2o7enwK/LN2SVdoWonTOPq7xOw1AOGlBck0wWo2krAkPKCZLoAVVsJGFJekEwXoGorAUPKC5LpQoG/GoDfo6KtthAwpLwgmS5A1VYChpQXJNOFSVXn9VfLT5BPeJ62ZH4MCf7q/QRUtdw0KTdlqM0OLuerejGj6rz anUf4QI7dbsb/NX7iaZq5a mY8/o59IcsZJb1ZIs/mq6ufBBk 2nnbQ1Hf7qQ4RSdWn81XK/IO 6p75Y95TMq7CqOpe/WipBPTJh2hoxDgn 6kOEUjUhVS3DU77Dn1J1SeWvlupSMZyhavirjxJZ1erW/LOqTuev/nJbDX/1USKruv4LbXVJ6K9ue8L8c/soSXtI7bgX/uoxwVUtmy45c1Z/QNV5/dXqT7MMzggJ/uoJgqtats8q2 lVnddfrdQrH2Thvl4Nf/UEwVUtNzgoDadX9YUELPWAIeUFyXQBqrYSMKS8IJkuQNVWAoaUFyTThQInJgC/R631PyBqIONPOgSMAAAAAElFTkSuQmCCAA==








=MAX(FREQUENCY(IF(??