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.
- Scott1976Dec 05, 2019Copper Contributor
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 🙂
- mathetesDec 05, 2019Gold Contributor
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.
- Scott1976Dec 16, 2019Copper Contributor
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
- Detlef_LewinDec 05, 2019Silver Contributor
=SUMIF(A1:A19,"x",F1:F19)
- Abiola1Dec 05, 2019MVPHello,
Upload of a sample data will be more usefulness than the image