Data Validation List with Formulas

[CadenChen]

Hi, I was searching google and figured this is from list-data validation. However, I can't seem to add formulas / functions in Data Validation. Will be lovely if someone could help me out!

 

[#2 · Accepted solution]

@CadenChen 

That is the total row of an Excel table and not data validation.

https://support.microsoft.com/en-us/office/total-the-data-in-an-excel-table-6944378f-a222-4449-93d8-...

[#3]

@CadenChen 

On screenshot there are function which you use to summarize data in Table (or add your own one). Where do you use data validation?

[#4]

oh i see, thank you so much!

[#5]

saw it, thank you so much!