Can you Sumproduct 3 variables

[markwight]

I am looking to get 3 variables to Sumproduct
Column A = Dog
Column B= Black
Column C = spayed

thanks

M

 

[Brian from Maui]

Have you tried extending the concept for a third array from the formula that was provided to you?

 

[markwight]

yes

yes but with no luck. I added it exactly

 

[markwight]

Wait got it

THANK YOU

 

[Brian from Maui]

Re: yes

yes but with no luck. I added it exactly

Care to post the formula?

Edit,

Here's a good read

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Scott Huish]

Link to your other thread:

See: http://www.mrexcel.com/board2/viewtopic.php?t=233745