Hi,
I have a formula that excludes one category from a sumproduct and I am trying to work out how to add a second.
The formula is =SUMPRODUCT(--($C$156:$C$1156<>"Cats"),I$156:I$1156) but I would also like to exclude "Dogs" - does anyone have any ideas?
Thanks
Bookmarks