Forum Discussion
Completing sum above based on a different column
- I have a spread sheet that I am trying to do a conditional addition of above rows based on entry in column A. If someone can help with an idea. that would be great.
I have added a sample and the area I am hoping to add. Hopefully this helps
9 Replies
Scott1976 Any chance you could upload the actual spreadsheet? That's far more helpful than an image. It looks like you're asking about additions in column I, but that column isn't showing in your image.
And what are the other kinds of conditions that might arise? To get a good answer, your situation needs to be more clearly described.
So Detlef has given you an answer.
Is that, though, what you need longer term for all other conditions? That's what's not clear to me.
I'm also--to be frank--a bit confused as to why your spreadsheet is laid out as it is, with some data in alternating rows, some blank cells. Leaves me wondering what goes with what! And that's why it's not clear to me whether the formula you got will work for future situations, where "x" is in a different spot. If it is exactly what you need, that's great. If it's not, please give some more examples and an explanation of the underlying "sense" of the layout.
- Hello,
Upload of a sample data will be more usefulness than the image
