Count and Sum Values in Excel

Overview

This app automates the process of analyzing Excel data by counting the number of items in Column A and summing the values in Column B. It reads data from a specified Excel file and outputs the results into a new sheet within the same file. This makes it easier to organize and analyze your data without manually performing calculations, streamlining your workflow.

How to Use

1. Download the app from Octoparse AI app store.

2. Launch the app in your list.

   

   1. Parameter Description

      

      1. FilePath_Excel: Select or enter the path to the Excel file you want to analyze. Ensure the file has headers and that the data to be processed is in columns A and B.

      2. SheetName: Specify the name of the sheet that contains the data for analysis.

   2. Click "Run application"

3. Output

   The app it will create a new sheet in the source file that includes the counted and summed data.

   

Notes

• Both input parameters must be filled in for the app to run.

• Do not use the mouse or keyboard while the app is running to avoid interruptions.

Troubleshooting

Encounter obstacles but don't know how to resolve them when executing the app?

Please contact our support team at [email protected] to find the way out!