Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Power Automate Desktop
Unanswered

Sum a filtered Excel column

Like (0) ShareShare
ReportReport
Posted on 27 Nov 2022 04:17:40 by 22

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? 

GJH_0-1669522098781.png

 

  • garthh Profile Picture
    138 on 28 Nov 2022 at 07:06:00
    Re: Sum a filtered Excel column
    VJR
    As always, thank you 
    As a newbie to all this I’ll give it a go and get back
     

     

  • VJR Profile Picture
    7,635 on 28 Nov 2022 at 03:28:02
    Re: Sum a filtered Excel column

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 147 Super User 2025 Season 1

#2
Riyaz_riz11 Profile Picture

Riyaz_riz11 54 Super User 2025 Season 1

#3
Nived_Nambiar Profile Picture

Nived_Nambiar 30 Super User 2025 Season 1

Overall leaderboard
Loading started