Forum Discussion
Excel Amature
I'm trying to create a spreadsheet that will help calculate quantities by part name. I'm in the construction industry and while doing "take offs" on a set of blueprints parts are listed repetitiously...
Can excel recognize "3-inch pvc wye", regardless of the input location, and total the amounts in a separate column?
Yes. You'd use the SUMIF function. Here's a resource that explains it. Come back if you need more help in implementing it.