Hi,

I need to find a Sumif formula compatible whith Excel 2003 with 2 or 3 criterias:
sumif.jpg

The basic formula is
=SUMIF(ART_CollUnit;CALC_CollUnit;ART_FcstO30M)

ART_CollUnit is the column C
CALC_CollUnit is the criteria (egg TCFR08)
ART_FcstO30M is the column X for conditional sum.

However, I also need to select a criteria in column A and B (egg "01" and "1. TRADE")

I can't find a solution based on sumif and AND, MATCH, IF...

Thank you for your help.