How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

What exactly are you trying to test? Your ranges are all different sizes and
SP insists on same size ranges to work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

I am testing these ranges as a COUNT function for data values set upon
those arguments. If sumproduct isn't suitable for these size ranges are
there any other formulas that i can used.

Imran


Bob Phillips wrote:
What exactly are you trying to test? Your ranges are all different sizes and
SP insists on same size ranges to work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

Hi
With the different ranges, it looks like you are adding four sums with
one criteria each?

regards
Paul

wrote:
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

Yeah that right! what other alternative method can i used?

regards
Imran

wrote:
Hi
With the different ranges, it looks like you are adding four sums with
one criteria each?

regards
Paul

wrote:
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

Hi
Do your four seperate sums and add them together. Why do you need an
alternative to that?

regards
Paul

wrote:
Yeah that right! what other alternative method can i used?

regards
Imran

wrote:
Hi
With the different ranges, it looks like you are adding four sums with
one criteria each?

regards
Paul

wrote:
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

I am updating a rating sheet, which has rating between 1 to 5 where I
want to collated this information from one sheet to another with these
ranges.

Imran

wrote:
Hi
Do your four seperate sums and add them together. Why do you need an
alternative to that?

regards
Paul

wrote:
Yeah that right! what other alternative method can i used?

regards
Imran

wrote:
Hi
With the different ranges, it looks like you are adding four sums with
one criteria each?

regards
Paul

wrote:
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks

How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
 

Maybe you want

=COUNTIF(D12:P16,"=4")+COUNTIF(D21:P22,"=4")+COU NTIF(D28:P34
,"=3")+COUNTIF(D23:P23,"=3")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
I am updating a rating sheet, which has rating between 1 to 5 where I
want to collated this information from one sheet to another with these
ranges.

Imran

wrote:
Hi
Do your four seperate sums and add them together. Why do you need an
alternative to that?

regards
Paul

wrote:
Yeah that right! what other alternative method can i used?

regards
Imran

wrote:
Hi
With the different ranges, it looks like you are adding four sums
with
one criteria each?

regards
Paul

wrote:
I have been trying to create a sumproduct formula for a excel
sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks