One way to use a Google Sheets function to tally answers from several different columns that share the same header is to use the SUMIF function.
Here are the steps to use SUMIF:
For example, if you have three columns labeled "Fruit" and you want to tally how many apples, oranges, and bananas you have, you can follow these steps:
Repeat the process for other fruits, typing the respective fruit name in the criteria argument to tally how many of each you have.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-07-12 01:16:05 +0000
Seen: 9 times
Last updated: Jul 12 '23
How can I utilize a view above and between bottom tabs in React Native Navigation?
How can the header label be made dynamic in react-table?
How to retrieve header and body data in Next.js using prefetch function?
How do I add a search bar to the header of my Square Space 7.1 website?
How can I use Office Script to delete all rows in Excel except for the first header row?