equate Text values to numbers for addition.

Originally Posted by Ron Coderre

See if this example does what you want...

With these values in A1:E2
Old Navy	Ross	TJX	Target	Walmart
26	8	8	4	4

And
Various Yes/No combinations under those values.

This formula assigns values to the Yes responses:
F3: =SUMPRODUCT(($A3:$E3="yes")*$A$2:$E$2)

Is that something you can work with?

Excellent..! You are my man...Ron Coddere


Can u please explain the code...I have attached the file for others who also can make use of this excellent piece of code....

SUMPRODUCT is really a unique funtion but have not absorbed it so well to use it too often...

If u have any good examples of when it can be used it would be wonderful to have a look...

Thanx once again..