Hi
Is anyone able to help come up with a formula that will total cells with more than one value in each cell.
Basically trying to plan out a wall I'm tiling in the bathroom and want a formula that will sum up cells with more than one value in each cell as each cell will have a length and a width value so I want to know the sum of the values ending in "H" for height and a sum of the values ending in "W" for width.
Simple example below
21w x 10h 66w x 10h 21w x 10h 21w x 30h 66w x 30h 21w x 30h 21w x 10h 66w x 10h 21w x 10h
So for each column I want the total height and for each row the total length. Results would be 50H for each column and 108W for each row
Thankyou!
Bookmarks