|
|
Sorry about the confusion. I often name ranges
--
Don Guillett
SalesAid Software
"Dale" wrote in message
...
Thanks Don and Max
Your solutions worked perfectly after I adapted the range. I
misinterpreted the initial formula that Don gave me. Thanks again
Max wrote:
What Don Guillett gave should work ..
=sumproduct((rngb={1,2,3})*rngA)
I keep getting the error #Name?
Think you didn't adapt "rngb" and "rngA" in Don's formula to suit ..
Maybe try this translation:
Put in say, D2: =SUMPRODUCT((C2:C100={1,2,3})*B2:B100)
Adapt the ranges: C2:C100, B2:B100
to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Dale" wrote in message
...
Thanks for the quick response, however, I must be doing something wrong,
I keep getting the error #Name? Any Ideas?
Don Guillett wrote:
try
=sumproduct((rngb={1,2,3})*rngA)
|