Not sure you're looking for a VBA solution, and this can likely be accomplished with some SUMIF's, but I suck at Excel formulas.
To use this code:- Open the VBA editor by pressing Alt+F11 in Excel
- In the window that opens, you'll see a project explorer window on the left hand side
- Find your spreadsheet, then listed under that, find the sheet you want this to run on (in your example, it would be Sheet1)
- Double click that sheet
- Paste the code in the white space to the right
Now the code will run automatically any time you enter a number into column G, assuming columns C and F are also filled out for that row.
Bookmarks