Google-sheets – How to compare each value from two rows column by column and put the result in one cell in Google Spreadsheets

google sheets

I have something like this

Row

1->   1   3   4   2   1   1

2->   2   1   3   4   2   2

I want to find how many values of row 1 are greater than the ones in row 2 and have them in a cell.

The result should be 2 since I want to only compare column A with A, B with B, and not A with B, A with C, etc.

Best Answer

Please try:

=sum(ArrayFormula((A1:Z1>A2:Z2)*1))

and adjust end column reference to suit.

You could instead try =sum(ArrayFormula((1:1>2:2)*1)) but would then limit use of the first two rows of columns AA onwards without risk of erroneous results.

Related Solutions

Google Sheets – Compare Each Cell of Two Rows in Google Sheets

Try this:

=arrayformula(sumproduct((T2:AM2=T3:AM3)))

What this will do is compare each cell, return a 0 or 1 if true, and then sum up the counts.

Arrayformula() is a way to apply a function to an array, rather than a single cell.

Google-sheets – How to make Google Sheets tell me how many of each date are in a column

You can reproduce the required table using a formula (this will only work on the newest version of Sheets):

=QUERY({A:A,A:A},"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 'Date', count(Col2) 'Number'",0)

And then reference that output for your graph.

If you are on the old version:

=ArrayFormula(QUERY(IF({1,1},A:A),"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 'Date', count(Col2) 'Number'",0))

Best Answer

Related Solutions

Google Sheets – Compare Each Cell of Two Rows in Google Sheets

Google-sheets – How to make Google Sheets tell me how many of each date are in a column

Related Topic