On Nov 12, 11:35*am, Gary''s Student
wrote:
Named ranges are o.k. if:

1. the dimensions are the same
2. don't use full columns

For example with A1 thru B20:

happy * me
happy * me
happy * me
happy * me
happy * me
happy * me
happy * me
happy * others
happy * others
happy * others
sad * * others
sad * * others
sad * * others
sad * * me
sad * * me
sad * * me
sad * * me
sad * * me
sad * * me
sad * * me

=SUMPRODUCT((A1:A20="sad")*(B1:B20="others")) displays 3
and
=SUMPRODUCT((label1="sad")*(label2="others")) displays 3

after the names have been assigned
--
Gary''s Student - gsnu200813

Thanks Garry,

I was using full columns.
When limited at same dimension as you suggested it works.

I appreciate your support.

Frank Gashi