sumif indirect

Hi All, I have a project I am working on where I was recently asked to separate the data capture sheet of a workbook (let's call this workbook 1) and capture it in another workbook (workbook 2). This was the formula I was using to capture the data within workbook 1...

So, I've come across the most difficult Excel problem I have ever seen. I'll let you be the judge. Please chime in, as I am really stuck. Essentially, I am trying to pull cost data (see Sheet B). Sheet A: <tbody> A -Unique Identifiers B -Admit Date (l) C -Discharge Date (l) D - Cost 1...

Following up on a similar post regarding summing scores across multiple sheets, I need to modify the formula that Aladin was so kind to provide to fit a different summary sheet. This time I need to split out the different skill levels within a category. Aladin used a way to concatenate the...

Hi everyone, longtime excel user and mrexcel lurker, first time poster. I'm running into some issues which probably are just due to my lack of excel knowledge. Essentially, here is what i'm trying to do (this is an example,but i'm trying to do this for larger amounts of data): Sheet 1: Row 1...