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

[ims121uk]

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 D1216 with this criteria >=4
second range is D2122 with this criteria >=4
third range is D2834 with this criteria >=3
fourth range is D2323 with this criteria >=3

anyone that can help me with this?

many thanks

 

[Bob Phillips]

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)

 

[ims121uk]

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

 

[paul.robinson]

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

regards
Paul

 

[ims121uk]

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

regards
Imran

 

[paul.robinson]

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

regards
Paul

 

[ims121uk]

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

 

[Bob Phillips]

Maybe you want

=COUNTIF(D1216,">=4")+COUNTIF(D2122,">=4")+COUNTIF(D2834
,">=3")+COUNTIF(D2323,">=3")

--
HTH

Bob Phillips

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