Excel Query Pal

Excel Query Pal

Upload Excel files or use samples, define search criteria, and sum values.

Upload Workbooks

Query Parameters

Worksheet Name(s) (Optional)

Enter comma-separated names. Case-insensitive. Leave blank to search all sheets in each workbook.

Find Values by Specific Cell Addresses?

Check this to sum values directly from cells like A1, B10. Uncheck to find values next to specific text.

Text Identifier

The text in the cell immediately to the left of the value you want to sum.

Match Type

How to match the 'Text Identifier'. Partial is case-insensitive.

Excel Query Pal v1.2.1