ExcelBanter - SUMIF question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMIF question (https://www.excelbanter.com/excel-discussion-misc-queries/121296-sumif-question.html)

Shan

SUMIF question

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

Teethless mama

SUMIF question

=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

All times are GMT +1. The time now is 06:38 AM.