I have a PAD flow using the formula below that sums the filtered column correctly
In another flow and have used the same formula - but get the result #NAME on the filtered column
Both columns are numbers only
Can anyone suggest a remedy/what to check?
Hi @GJH
You can use Excel as a database and achieve the same results versus Sendkeys which would be less reliable.
I have shared a query here to sum the values in the column.
The only thing you need to change is to add the filter clause to the SQL query depending on what you want to filter in your Excel.
Example: Select SUM(Age) from [Sheet1$] where [Age] > 2
Here is the official documentation for Running SQL queries on Excel.
eetuRobo
147
Super User 2025 Season 1
Riyaz_riz11
54
Super User 2025 Season 1
Nived_Nambiar
30
Super User 2025 Season 1