I wanting to create summaries of every product that is both the same size and color. Below are 3 simple examples showing both the original data and the resulting summary I wish to create. Can someone please tell me what formula I should use to create this?
P.S. It's not necessary to merge cells as I've done for the amounts below. Not even sure why I did that actually.
P.S. It's not necessary to merge cells as I've done for the amounts below. Not even sure why I did that actually.