'Count number of occurrences of People Chip in google sheet

Does google sheet support counting of People Chips? If not, is there an easy way to convert all the personal chips in a sheet to strings?



Solution 1:[1]

in some scenarios, you can use ISEMAIL like:

=SUMPRODUCT(ISEMAIL(A1:A10))

tho it's worth mentioning, that it does not differentiate between regular email in cell and people chips

enter image description here

and too convert chips into strings you can use TO_TEXT

=INDEX(TO_TEXT(A1:A10))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0