SUMIF question

[Shan]

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(C1>1,C1 <2)", D1100)

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

 

[Teethless mama]

=SUMPRODUCT(--(C1:C100>1),--(C1:C100<2),D1100)