I need your help Dear Vba Guru's..."Creating range in a variable data.."
 

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

I need your help Dear Vba Guru's..."Creating range in a variable data.."
 

=sumproduct(--(A1:A100="Anime"),--(B1:B100="a"))

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
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

I need your help Dear Vba Guru's..."Creating range in a variable data.."
 

Thanks a lot Tom!! It works!!! Great!!!

Tom Ogilvy wrote:
=sumproduct(--(A1:A100="Anime"),--(B1:B100="a"))

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
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