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 <[email protected]>,
Rob <[email protected]> wrote:
> I am currently using the following formula...
> =SUMPRODUCT((INDIRECT("$E$1:$AN$1")<>"Cat")*INDIRECT("$E$3:$AN$3"))
> I need to add another criterium "Dog". How do I modify?
Bookmarks