Thread
:
Help with Sumproduct with Indirect
View Single Post
#
1
Rob
Posts: n/a
Help with Sumproduct with Indirect
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
Reply With Quote