Try this:

=SUMPRODUCT(--(B11:B2000),--(F11:F200=$DW$11),--(K11:K200=$DW$12),B11:B200)

Biff

"StephenAccountant" wrote in
message ...
Hi,

I have to add some numbers in one column based on multiple criteria.

EG,

if cell b11 0 and Cell F11 = Cell$DW$11 and cell K11 = Cell $DW$12
Then
Add cells B11:B200.

Keep in mind that the criteria for each row must match.

Can I do this using sumif? I have a formula but it doesn't seem to work:

=sumif(B11:B200,and(B110,F11=$DW$11,K11=$DW$12),B 11:B200)