Forum Discussion
Solved
TO COUNT CELLS WITH MULTIPLE CRITERIA WITH COUNTIF FUNCTION.
TO COUNT CELLS WITH TWO CRITERIA. THERE ARE TWO CELLS WITH NUMBERS AS A VALUES. A B 80 85 78 82 77 83 89 84 90 92 I WOULD LIKE TO COUNT IF THE VALUE IS LESS THAN "80" IN THEFIRS...
You may try the SUMPRODUCT Function like this...
Assuming your numbers are in the range A1:B10, then try this
=SUMPRODUCT((A1:A10<>"")*(A1:A10<80)*(ABS(A1:A10-B1:B10)<5))
Adjust the ranges in the formula as per your requirement but don't refer the whole column in the formula as it would take a long time to calculate it.
You may try the SUMPRODUCT Function like this...
Assuming your numbers are in the range A1:B10, then try this
=SUMPRODUCT((A1:A10<>"")*(A1:A10<80)*(ABS(A1:A10-B1:B10)<5))
Adjust the ranges in the formula as per your requirement but don't refer the whole column in the formula as it would take a long time to calculate it.