mu1sjw
Last Updated: February 25, 2016
·
210
· ftsanjuan

Excel: COUNTIFS

Large data set? Need to count the number of occurrences of a particular value?

Try opening your file in Excel and use:

=COUNTIFS(rangeStart:rangeEnd, value) 

This will count how many times a particular value occurs between rangeStart and rangeEnd.