Hi

Why do you use INDIRECT here? Simply
=SUMPRODUCT(($E$1:$AN$1<"Cat")*($E$3:$AN$3))
will work in same way. Even better will be
=SUMPRODUCT(--($E$1:$AN$1<"Cat"),($E$3:$AN$3))

About your question - for which range will the additional criterium apply?
When you want to sum all values in row 3 with "Dog" or "Cat" in row 1, then
=SUMPRODUCT(--($E$1:$AN$1<"Dog"),($E$3:$AN$3))+SUMPRODUCT(--($E$1:$AN$1<"C
at"),($E$3:$AN$3))
When you want to sum all values in row 3 with "Cat" in row 1 and "Dog" in
row 2, then
=SUMPRODUCT(--($E$1:$AN$1<"Cat"),--($E$2:$AN$2<"Dog"),($E$3:$AN$3))


Arvi Laanemets


"Rob" wrote in message
...
Hi
I am currently using the following formula...
=SUMPRODUCT((INDIRECT("$E$1:$AN$1")<"Cat")*INDIRE CT("$E$3:$AN$3"))
I need to add another criterium "Dog". How do I modify?
Thanks
Rob