I have a large amount of data that I need to sum in various ways. I have no control over the format of the spreadsheet that contains the data as I receive it from an outside source and need to provide inputs back in this same format. I would like to find a way to write a formula that will return the value in the cell based on multiple criteria. I have two criteria columns and also two header rows that are criteria. I've attached a very simplified version of how the data I receive is formatted. My criteria is in cells A16:A20. I can't seem to hit the right combination of formulas to pull the value from the full range (C3:P11) that matches that criteria. Any help would be appreciated.
Bookmarks