Forum Discussion
Completing sum above based on a different column
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.
mathetes Added a sample and indicated formula I am looking to replicate based on where X is placed in Column A. Hope this will help solve my problem 🙂
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.
mathetes I have been given permission to place a copy of the full work sheet on here. It is not mine it is why I needed permission. This is a sheet to easily calculate heat and vapor transfer. The X will indicate what the vapor barrier is for each structure.
So again I am having an issue with getting the correct value automatically in N45
=SUMIF(A1:A19,"x",F1:F19)
- Hello,
Upload of a sample data will be more usefulness than the image
