I have an issue plaguing me with Excel that has to do with the =SUMIFS function. Although I have been able to include execute sorting by specific criteria to another worksheet against data on another worksheet, I cannot seem to figure out how to exclude data based on a specific marker in a column. Unfortunately, the data is proprietary so I cannot share it, but I will provide a clear explanation of the behavior I need and the basic structure of my workbook source. I am using the following below for a particular cell:
To explain, the first column matched after the range is looking for the month of December or "12" numerically. The second is looking for the physical year. The third is looking for a parent account code, in this case "01". The last is matching an child account code, "00001".
The data comes from a proprietary system employed by the organization which generates an Excel report--I then copy/paste this report into my workbook and my scripted cells generate sum totals from the criteria. This is the first type of cell I use this function for. However, I have another worksheet that needs to access the same data, the same way, but exclude everything except a specific item. Between the physical year and the parent account code in the example above, there is one more additional piece of data that distinguishes what the information applies to. We'll call this a item code for the sake of simplicity, which suggests what the money was spent towards. This is where I come into a problem.
The data that needs to be excluded isn't marked with anything. The report generates puts a singular (or possibly plural) number of blank spaces into that searchable cell. Normally, an item code will have two alphanumeric digits, such as 'A1'. Initially I tried the following:
Unfortunately, that doesn't work. I can't seem to find a reference to identifying 'white space' in a cell when performing a function to match and sort.
I sure hope someone has run into this problem, because searching books and Google hasn't given me any clear leads, just a host of avenues that haven't panned out (could be my execution, always have much to learn). Thank you for any assistance you can provide!