Is it possible to construct a simple formula, along the lines of "sumif".
The data range has descriptions in column A, and sales figures by month in columns b through Z.
What I need is a summary total by month of all the lines, where a known sting is found within the description in column A. There are multiple known strings that this needs to cater for.
The data range has descriptions in column A, and sales figures by month in columns b through Z.
What I need is a summary total by month of all the lines, where a known sting is found within the description in column A. There are multiple known strings that this needs to cater for.