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