Hi, I posted a question recently which this excellent community very kindly helped me with. However, the spreadsheet has evolved a little since then and I'm hopefully looking for another solution.
What I'd like to do is have a formula that would 'find' all Jan-21 Type A amounts and sum the corresponding amounts in H2:L6. Then do the same for Jan-21 Type B, Feb-21 Type A and Feb-21 Type B.
The blue box shows the outcome I'm looking for but I'm a bit stuck with the formula. I've tried using a SUMIF range but just get a #VALUE.
Thanks for any help in advance.
What I'd like to do is have a formula that would 'find' all Jan-21 Type A amounts and sum the corresponding amounts in H2:L6. Then do the same for Jan-21 Type B, Feb-21 Type A and Feb-21 Type B.
The blue box shows the outcome I'm looking for but I'm a bit stuck with the formula. I've tried using a SUMIF range but just get a #VALUE.
Thanks for any help in advance.