abid.aries
New Member
Dear Experts,
Hope you all doing great and had a great week.
My problem is that, This is my formula based on AND & countifs.
Below formula is calculating Late "L" and when it is true it return 0.
=IF(AND(R281="L",OR(COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=3,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=6,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=9,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=12,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=15,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=18,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=21,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=24)),0)
Problem is that it is calculating all the data and take too much time and processing speed and ultimately slow down my working.
I need an array formula that eliminate time and processing consumption.
Thanks in advance.
Hope you all doing great and had a great week.
My problem is that, This is my formula based on AND & countifs.
Below formula is calculating Late "L" and when it is true it return 0.
=IF(AND(R281="L",OR(COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=3,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=6,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=9,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=12,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=15,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=18,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=21,COUNTIFS($A$2:A281,A281,$Q$2:Q281,"L")=24)),0)
Problem is that it is calculating all the data and take too much time and processing speed and ultimately slow down my working.
I need an array formula that eliminate time and processing consumption.
Thanks in advance.