Hello,
I am a novice Excel user. I am trying to find a formula that will allow me to calculate the sum of a range of cells only if the cell adjacent to each cell in the range is empty. If the cell adjacent to the criterion cell is not empty, I would like Excel to use that cell for the sum instead. For example:
Excel Example.png
I have entered in my projected expenses for the month. In the actual expenses column I have entered in the data as those expenses have occurred. Sometimes the projected expense is higher than the actual expense. Sometimes the actual expense is $0. The blank cells in the actual expense column are for expenses that have not occurred yet.
I would like to calculate the sum of my projected expenses that take into account the actual expense amounts that have already occurred. Right now I am currently using a Pivot table which calculates the total sum of all cells in the projected expense amount range which comes out to be $6278.27. But what I want to see is $3424.27 which uses the actual expense amounts when they are present instead of using only the projected expense amounts.
I apologize if this is confusing! I'm trying to figure out a solution and am having a hard time figuring out how to articulate the issue which makes it even more challenging! Any guidance is appreciated. Thank you.
Bookmarks