'Determine the number of terms by year in Google Sheets

I have two tabs in my Google Sheets file. One of these tabs contains our guests' data.

datas

The other is a summary of payment methods by years.

Summarise

Could you explain me, how can I fill in the summary cells with the datas from the other tab?

Thank you!

arraysfiltercountgoogle-sheets-formulagoogle-query-languagec++for-loopopenmp


Solution 1:[1]

try:

=QUERY({Adatok!A2:E}; 
 "select Col5,count(Col2) 
  where Col5 is not null 
  group by Col5 
  pivot year(Col4)
  label Col5'Payment method'")

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0

Related Questions