=SUMPRODUCT(--(C1:C1001),--(C1:C100<2),D1:D100)

"Shan" wrote:

I wanted to conitionally SUM All Ds For which the correspoding C cell is
1.* or 2.* or 3.*

I tried something like following. which did not work
=SUMIF(C1:C100, "=AND(C11,C1 <2)", D1:D100)

C D
1.1 5
1.2 4
1.3 3
2.1 1
2.2 1
2.3 1