You’re offline. This is a read only version of the page.
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.
#1
eetuRobo
18
Super User 2025 Season 1
#2
John_Mavridis
6
Microsoft Employee
#3
Brad Darragh
4
Share
Report
All responses (
Answers (
