Hi

Domenic formula SUMPRODUCT is perfect. But Bob formula not working.I hope
this is my mistake.The MOD not understandability for me.Thanks.

"Domenic" kirjutas:

In article ,
"Bob Phillips" wrote:

You could do it with SUMIF no need for SUMPRODUCT...

Definitely! I should have used SUMIF... :)

...and it could return a
result from the wrong rows if say A14=G4 and A15 is a value.

True, but I don't think that would be the case. Of course, I could be
wrong... :)