Modified SUMIF

[makinmomb]

I am using

=SUMIF(D:D,"216.*",I:I)

I am bugged to edit the formula to change 216 to another code
This is wasting time

See file attached my n2 to be modified do the sales summing according to codes on column O and then drag down

To be utilised to arrive to sales by category of stock series

[makinmomb]

If the answer is correct it should arrive to the following sales

6379.28	216
6283.62	103
663.79	104

[AlKey]

Use this

=SUMIF(D:D,O2&"*",I:I)

and pull formula down

[makinmomb]

This is it I was writing it without the quote in the morn, lovely

=SUMIF(D:D,O2&*,I:I)