CODEWITHSUNDEEP
google-sheetsspreadsheet
Django
Django

Reputation: 55

Google Sheets: How set value from two matched columns?

i'm trying to transform data from a row only list to a row-column structure.

I got data in I:K and want to set the values from K to the corresponding cells in A:H where Date and Time Values from I & J have to match within A:H.

example sheet

Does anyone know how to do this with Google Sheet system functions?

Upvotes: 1

Views: 51

Answers (1)

Kin Siang
Kin Siang

Reputation: 2699

Yes, it can be achieved by using sumifs formula, simple and straightforward, here is the formula:

=SUMIFS($I$2:$I$13,$G$2:$G$13,$A5,$H$2:$H$13,D$1)

And this is how the Gsheet look like, accept if helping you :)

enter image description here

Upvotes: 1

Related Questions