Hi all, first time posting hopefully this is the right place to ask.
If anyone can help me please, I'm trying to use a subtotal formula that calculates values in one column based on the text in another column.
Below image is what I'm trying to achieve. If I filter on Colum A for "A" it gives me the total then in in Cell B12 where I'd have the formula.
Hopefully I've made sense and really appreciate any help. Love this Forum!!
If anyone can help me please, I'm trying to use a subtotal formula that calculates values in one column based on the text in another column.
Below image is what I'm trying to achieve. If I filter on Colum A for "A" it gives me the total then in in Cell B12 where I'd have the formula.
Hopefully I've made sense and really appreciate any help. Love this Forum!!
