Forum Discussion
Adding a fixed number only if the next cell has a value
Hi I'm building a sales/ productivity tracker. I would like to add the sales goal to the month end, only if there is a value beside it. Example: This is my formula for every Monday Sales Goals i...
Greetings! Attached please find workbook conditions met a. Five weeks Goal and Achievement Sheets. b. Consolidated Summary Sheet. c. Sales achieved cells (C7 in sheets Week1 to Week 5) only accept data <= Goal Cells(B7 in Sheets Week1 to Week5) d. Summary Sheet (Total Sales Goal(Month) only add up when data is present in each Sales achieved cells(C7 in sheets Week1 to Week 5). e. The total Sales Achieved cell in Summary Sheet will show total only if above condition "d" is met. Thanks,