Calculating Column Totals in Excel for Returned Values

Aaron · 2025-05-05T18:55:40.344255+00:00

how can i see in a column the total number of rows that have a value returned? similar to a =sum function in excel. i want to see the totals per column in a single table

To see the total number of rows with a value per column in a single table, you can use our "Lookup Rows" feature. Here's how: 1. Use the "Lookup Multiple Rows in Other Table" action. 2. Set the table you want to search as the same table you're working in. 3. For each column, create a lookup that counts non-empty cells. 4. Display the results in a new row or column. This approach will give you a count of non-empty cells for each column, similar to Excel's =SUM function for counting non-blank cells. If you need more detailed instructions or encounter any issues, please ask to talk to a person for further assistance.

Sources: Lookup Rows | Documentation | Clay University Customize your table view | Documentation | Clay University

1 comment