ExcelBanter - SUMIF

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

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

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

Tatebana

SUMIF

The SUMIF formula works fine if I have only one criteria.

Is it possible to have 2 or more?

For a Sales Statistik I have in one column the months and in another the
code for an article.

Toppers

SUMIF

Look at SUMPRODUCT:

=SUMPRODUCT((A1:A100=month)*(B1:B100=code)*(C1:C10 0))

HTH

"Tatebana" wrote:

The SUMIF formula works fine if I have only one criteria.

Is it possible to have 2 or more?

For a Sales Statistik I have in one column the months and in another the
code for an article.

All times are GMT +1. The time now is 02:46 AM.