google sheets countuniqueifs count unique criterion скачать в хорошем качестве

google sheets countuniqueifs count unique criterion

Use the Google Sheets COUNTUNIQUEIFS function to count unique data in a range, based on the specified set of criteria range and criterion. You can specify more than one set of criteria range and criterion. ---------------------------------------------------- If you are interested in the COUNT, COUNTIF, COUNTIFS, or COUNTUNIQUE function, here are the links to the video tutorials: COUNT function tutorial:    • Google Sheets Count | How to Use COUNT in ...   COUNTIF function tutorial:    • COUNTIF Google Sheets | How to Use COUNTIF...   COUNTIFS function tutorial:    • How to use COUNTIFS in Google Sheets | COU...   COUNTUNIQUE function tutorial:    • Google Sheets COUNTUNIQUE Function | Count...   ---------------------------------------------------- Here is the format of the COUNTUNIQUEIFS function formula: =COUNTUNIQUEIFS(range, criteria_range1, criterion1, [criteria_range2], [criterion2], ...) Start the formula with an equal-to symbol. COUNTUNIQUEIFS is the name of the function. range is the spreadsheet area from which to get the count of unique items. criteria_range1 is the spreadsheet area to which the criterion is applied. criterion1 is the criterion to apply for criteria_range1. criteria_range2, criterion2, and others, is optional, and is the additional set of criteria-range and criterion. Let's look at two examples of the COUNTUNIQUEIFS function formula: Example 1 =COUNTUNIQUEIFS(A3:A12, B3:B12,"=5000") The above google spreadsheet formula returns unique values in the spreadsheet range A3 to A12, if the criterion are met. The function will apply the criterion "=5000" to the range B3 to B12. The count of cells in this range, which meet the criterion, with a corresponding unique item is returned. Example 2 =COUNTUNIQUEIFS(A3:A12, B3:B12,"=5000", C3:C12, "300") The above google sheets formula returns the unique data in the spreadsheet range A3 to A12, if both the criterion are met. Take a look at this video, which gives the steps to use the Google Sheets COUNTUNIQUEIFS function with an example.