All,
I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer.
I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this example. I've got the same 18 sub categories below each with the spacing defined below. I've then got the weeks (the first monday) for the year across the columns. On sheet2 I've got the locations, in one column, labeled one after the next with no spacing etc. One example of what I would like to do is sum, by main category, the subcategories, labeled "1" and "2" in this example on sheet 2 with a defined number of weeks. In some instances I will be pulling just one subcategory and others it will be multiple. Any help one can provide is much appreciated. Thank you!
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer.
I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this example. I've got the same 18 sub categories below each with the spacing defined below. I've then got the weeks (the first monday) for the year across the columns. On sheet2 I've got the locations, in one column, labeled one after the next with no spacing etc. One example of what I would like to do is sum, by main category, the subcategories, labeled "1" and "2" in this example on sheet 2 with a defined number of weeks. In some instances I will be pulling just one subcategory and others it will be multiple. Any help one can provide is much appreciated. Thank you!
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> </tbody> |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>