Hello all,
Brand new to the forum so apologies in advance for any missteps.
I am trying to consolidate some data in a 400 row spreadsheet with about 20 columns. What I am looking for is a formula that will Sum all dollar values in column B (highlighted in blue) IF the value in column C (highlighted in green) is the same. In theory, all other data in the row should be the same, so only these two cells are of concern. Is there a way to sum the data highlighted and reduce the number of rows per unique entry in column C to a single row? I have tried looking through SUMIF options but haven't been able to make progress.
Hopefully an image of what I'm describing is attached here:
SumCells.jpg
Thanks in advance!!!
Mike
Bookmarks