I have attempted to combine the SUM + IF functions in hopes of distinguishing between different categories of cells within one range on a spreadsheet and then summing these same categories on a different spreadsheet, but I'm not sure it's even possible much less figured out how to formulate such a function. I'll explain my problem below and have attached sample spreadsheets of my data and my desired outcome.
The first spreadsheet is the data of product prices, their price adjustments, and categories. Column B contains the price, column C is where I manually enter the adjusted price dependent on the category, and column D is where the categories are differentiated in the column by conditional formatting (FULL is green, DISCOUNT is blue, and COST is red).
The second spreadsheet is where I want the product prices to be linked to the first spreadsheet, but the problem arise when you attempt to get a total of the prices in column C. The simple way to get a total for each category is to manually select each cell within a category and use SUM (e.g., =SUM(C3,C7:C10) for FULL), but this is incredibly inefficient for numerous products that are recategorized frequently (e.g., a product that is DISCOUNTED one day is FULL price the next day). Also, it should be noted that I need products in the COST category to have their ORIGINAL price (data in column B) summed together. Therefore, what I need is a formula that can recognize the category of each price then return a total (SUM) for each category. This would be a great help to me, because the second spreadsheet would automatically update all I need once the data from the first spreadsheet is correctely summed up!
PLEASE HELP lol.
Bookmarks