sumifs with multiple criteria

[greentree0021]

I have used the below function to add only those numbers from France!AQ5:AQ213 that contains either "C4" or "C 4" in France!AP5:AP213.

=SUM(SUMIFS(France!AQ5:AQ213,France!AP5:AP213,{"C4","C 4"}))

Now, I wish to add one additional criteria:

• add only those numbers from France!AQ5:AQ213
• contains either "C4" or "C 4" in France!AP5:AP213
• AND contains either "a" or"A" in France!D5:D213

Thanks.

 

[Peter_SSs]

Welcome to the MrExcel board!

Try

=SUM(SUMIFS(France!AQ5:AQ213,France!AP5:AP213,{"C4","C 4"},France!D5:D213,"A"))

BTW, what is the name of the sheet that this formula is on?