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

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

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

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

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

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

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

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