Hello,
I am hoping that someone can help me with the following issue. I need a formula that can sum up the total values in multiple columns based on the column headings plus criteria in other columns.
I've shown an example of the issue below (workbook attached).
Month Product Store A Store A Store B Store C
April Couch 300 242 14 3
May Sofa 131 413 131 3,242
June Bed 1,413 1,413 2,422 242
July Table 1,312 436 23,245 242
For example, in this instance I want to summarize the total values in the columns Store A for the criteria Month = April and Product = Couch. The value would be 542 using this criteria.
Does anyone know how this could be done?
Bookmarks