•4 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automate a process in Excel where I need to add numerical data of one column based on data of another column and populate the result in yet another column
I have data in two columns - Column F and Column G in Excel. Column F contains numerical data and Column G contains only zeroes in certain cells . I need to add only those corresponding numerical data of Column F , which are lying between two adjacent zeroes of Column G. Please refer to the table below . I need to populate - 'Total Count at the end of the Day' without manually adding the data in 'Count' Column. For example , the corresponding numerical data for 'Count' column are 4, 3 and 0 which are lying between first two zeroes of 'Temporary Variable' - column G. The result of the sum , i.e. 4+3+0 =7 is to be populated in Column H and in the row above the second zero of Column G .
| Date | New Grievances sent to Subordinates | Action Taken on Reopened Grievances | New Grievances sent to Sections | Grievances Replied | Count | Temporary Variable | Total Count at the end of the Day | Progressive Total Count (As on the Current Date) |
|---|---|---|---|---|---|---|---|---|
| Dt:1 | 0 | 0 | ||||||
| a | b | c | d | 4 | ||||
| e | f | g | 3 | |||||
| 0 | 7 | |||||||
| Dt:2 | 0 | 0 | ||||||
| e | h | k | n | 4 | ||||
| f | i | l | 3 | |||||
| g | j | m | 3 | |||||
| 0 | 10 | |||||||
| Dt:3 | 0 | 0 | ||||||
| o | p | r | s | 4 | ||||
| q | y | t | 3 | |||||
| u | 1 | |||||||
| 0 | 8 | |||||||
| Dt:4 | 0 | 0 | ||||||
| v | w | 2 | ||||||
| x | 1 | |||||||
| 0 | 3 | |||||||
| Total Count at the End | 0 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#row zero
#rows.com
#cloud-based spreadsheet applications