Been trying to solve this one with SUMIF, COUNTA, COUNTIF and could not quite make it work. I have a feeling I am missing a column or a combination of these formulas somehow.
Glass windows come in various sizes, ie. 2106 - but each window size there are 3 types of windows - ie. Obscure, Awning and Double Hung (OBS, AWN, D/H).
I am trying to summarize each of the window size and obtain its location in the house as well.
Details are further explained in the Excel document attached.
Bookmarks