To count based on multiple criteria we use COUNTIFS function in Microsoft Excel.
Excel function COUNTIFS is used to count the entries in multiple ranges and with multiple criteria.
To sum based on multiple criteria we use te Sumifs function in Microsoft Excel.
SUMIFS:“SUMIFS” function is used to add the multiple criteria with multiple range.
Let’s take an example to understand how you can count based on multiple criteria.
Example 1: We have data in the range A1: C28. Column A contains theDate, column B Name and column C contains Revenue.
In this example, we will count the number of collected revenue by a member on a particular date.
To Count the number for multiple criteria follow belowgiven steps:-
If you want to sum the Revenue based on these multiple criteria follow below mentioned steps:-
To convert the formula into value use the “Paste Special” option:-
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 firstname.lastname@example.org
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.