How can I count how many times a unique row appeared in my google sheet?-CodePudding

Is there a way to count how many times a unique row appeared in my sheets?

Here's a sample link:

I need to count how many times "Apple | 10 | 9 | 1" and "Orange | 12 | 10 | 2" appeared.

I tried using this:

={UNIQUE(A2:D8, false), ARRAYFORMULA(COUNTIF(A2:D8, UNIQUE(A2:D8)))}

However, it counts individual unique cells, not the whole row.

CodePudding user response：

See if this helps

=QUERY(Sheet1!A1:D, "Select A, B, C, D, count(D) where A <>'' group by A, B, C, D label count(D) 'Count'", 1)