In this article, we will learn how to count the number of values between a lower and upper limit. We will use “SUMPRODUCT” function in Microsoft Excel to get the desired outcome.
SUMPRODUCT: This function is used for adding all the numbers in a range of cells.
The syntax of SUMPRODUCT formula:- =SUMPRODUCT(array1, [array2],…..)
Let’s take an example to understand how we can count the number of values between a lower and upper limit in Microsoft Excel.
We have table in Range “A1 to E11” in which column A contains Agent list, column B contains no. of sales for Q1, column C contains no. of sales for Q2, column D Q3 and column E contains for Q4.
In this data, we want to count the number of agents who are having the score greater than to 10 and less than 25.
To count the number of value between a lower and upper limit in Microsoft Excel, follow below given steps:-
What if we require the same for a particular agent?
Follow below given formula to return the no. of sales for agent between the range of 10-25:-
Conclusion:- This is all about that how we can count the number of values between upper and lower limit by using the SUMPRODUCT function in Microsoft Excel.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.