One way:
=SUMPRODUCT(--($E$1:$AN$1<"Cat"),--($E$1:$AN$1<"Dog"),$E$3:$AN$3))
convert ranges to INDIRECTs if necessary.
In article ,
Rob wrote:
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?
|