Hello and thanks. in the called sheet NationalParks.gsheet I have a series of data([DATA ESCURSIONE][NOME][PREZZO] ECC). in another sheet under the heading [TOTALE GIORNO] I would like to get the sum of all single service bookings for the date I entered.
=SUM(
SELECT( NationalParks.gsheet[TOTALE],
AND(
[_THISROW].[DATA ]=NationalParks.gsheet[DATA ESCURSIONE ],
NationalParks.gsheet[ESCURSIONE]=โEGADI DAYโ
)
) )
this is the error:Cannot compare Date with List in ([_RowNumber].[DATA] = NationalParks.gsheet[DATA ESCURSIONE])
can you help me?
[_THISROW].[DATA ] the tipe is data 12/06/2018 NationalParks.gsheet[DATA ESCURSIONE ] the tipe is data 12/06/2018
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |