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
Our take
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]
Read on the original site
Open the publisher's page for the full experience