In article ,
XLFanatico wrote:

=SUMPRODUCT(--($A$3:$A$3496="may")*($G$3:$G$3496="alexis")*($I$3 :$I$3496={"vis
it","pending","services" ,"agreement"}))
This formula works very well.
However the 3rd part may (visit,pending,services,agreement) may change
by month, either adding another word or taking off for example "services",
or both.
The 3rd part of the formula (visit,pending,services...) is in a list(another
sheet),
I just took those words an assigned a range tha I called "myrange".
Q. Is it possible to insert "myrange" in this FORMULA in order to avoid
writting all the words everytime I do the update?
THANK YOU.

Try...

=SUMPRODUCT(--($A$3:$A$3496="may"),--($G$3:$G$3496="alexis"),--ISNUMBER(M
ATCH($I$3:$I$3496,MyRange,0)))

--
Domenic
http://www.xl-central.com