You are viewing a single comment's thread from:

RE: Google Spreadsheet Formula Question

in #forumla7 years ago

Let's say you have the values spread across columns A,B,C.

A1 has the value "iPhone10", A2 "Shoes" and so, on.

If you enter the below formula in column D, in cell C1, you will get the results.

=COUNTIF(A:A,Sheet1!A1)

Sheet1 is actually the name of the google drive sheet (displayed at the bottom).

Now if you drag the formula in C1 down to other cells, you'll get the desired results!