SUMIFS with multiple criteria from 1 column

[BillieHynds]

Hi,

I am currently trying to work a SUMIFS formula looking at multiple criteria which works fine at the moment. We now have an instance where instead of summing if 1 criteria is met, I would like it to sum for 2 criteria in the same column.

=SUMIFS(Data!D:D,Data!A:A,$AO$3,Data!B:B,$AO$4,Data!C:C,$AO$2,Data!G:G,F26,Data!H:H,I26,Data!I:I,M26,Data!J:J,N26)

This is the current formula and where it says $AO$4, id like this to be $AO$4 AND $AO$5.

I've tried using using SUMPRODUCT and have not been successful.

Any help is much appreciated.

Thanks,

 

[Fluff]

Do you have any values in col B that match either 6311 or 6411?

 

[BillieHynds]

yes there is quite a lot of data as attached.

 

[Fluff]

You are doing this in xl365 aren't you?

 

[BillieHynds]

Yes correct

 

[Fluff]

Did the formula you posted work & give a value other than 0?

 

[BillieHynds]

Hi, I've managed to make your original formula work.

Thank you for all your help.

 

[Fluff]

Glad you sorted it & thanks for letting us know.