Hi
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?
Thanks
Rob
Hi
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?
Thanks
Rob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks