Hi @BI [131]
Could you please give a sample of your database?
Generally, we could use COUNTIF function to count the number of cells that meet a criterion.
I did a simple test, here I use formula =COUNTIF(A:A,E2) in cell F2, =COUNTIF(B:B,E2) in G2 and =COUNTIF(C:C,E2) in H2.
Then drag the lower right corner of the cell to quickly apply the formula to other cells.
If you have any questions, please provide a simple sample which may help troubleshoot your issue better.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.