Sumif working. Now its so easy.Thanks.

"Domenic" kirjutas:

In that case, use SUMIF instead...

=SUMIF(A1:E201,"A",A2:E202)

....it's more efficient.

Hope this helps!

In article ,
"Jaan" wrote:

Hi

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