My Dear Vba Guru's,

I'm doing a "sumif" formula for this project, my range is the "code"
and "downloads". My problem is the "code" is based on the "content
type" column and the "code" is only unique per "content type" If i make
a "sumif" formula without creating a range per content type group my
value will be overstated since the formula will compute also the same
code which is belong to the other "content type". The content type
range always varies so i can't make a fixed range also. Here's the
table below for your reference;

Content Type Code
Downloads
Anime a
1
Anime a
1
Anime b
1
Logos c
1
Logos a
1
Logos b
1
Ringtones e
1
Rintones b
1


Many many thanks in advance!!!

Jerome