Hi, I have been applying this formula in my excel spreadsheet but when i enter this formula in multiple cells, my excel calculating processor slows down and eventually crashing. Is there any way to make this formula work faster?
Purpose of formula: To count filtered data with 2 conditions (Dryness + absorbency being positive and subject name being pampers) applied within the formula.
Multiple cells as what i mean is that Dryness + absorbency is one of the fields. There is about 12 fields for 3 different brands ( Brand A [Pampers] , Brand B , Brand C)
Pivot table is not what i m looking for as for this project they need us to use excel formula to calculate.
Any alternate formula is also appreciated. Here is some a dummy excel sheet to try on but the formula applied is countifs which i tried the first time then moved on to sumproduct.
--(INDEX('Current Month'!$A:BJ,0,MATCH("Subject Name",'Current Month'!$A$1:$BJ$1,0))="Pampers"),
--(INDEX('Current Month'!$A:BJ,0,MATCH("Dryness + Absorbency",'Current Month'!$A$1:$AJ$1,0))="POSITIVE"),
Hope someone could help. Thank you