Sumifs

[kmbrly]

I am looking to create a SUMIFS using multiple criteria; not sure if what I am attempting is possible, any and all help is appreciated. Below is (to me) what would seem the logical formula, however, it is returning a incorrect sum. Thank you in advance.


=SUM(SUMIFS(E4:E44,F4:F44,{"14","15","16","17","18","19"},G4:G44,{"20","21","22"},P4:P44,"DOWNGRADE"))

 

[Marcelo Branco]

Welcome to Mr Excel forum

Using two array criteria one should be a horizontal array (values separated by commas) and the other a vertical array (values separated by semicolons)

See if this works
=SUM(SUMIFS(E4:E44,F4:F44,{"14","15","16","17","18","19"},G4:G44,{"20";"21";"22"},P4:P44,"DOWNGRADE"))

Hope this helps

M.

 

[kmbrly]

Welcome to Mr Excel forum

Using two array criteria one should be a horizontal array (values separated by commas) and the other a vertical array (values separated by semicolons)

See if this works
=SUM(SUMIFS(E4:E44,F4:F44,{"14","15","16","17","18","19"},G4:G44,{"20";"21";"22"},P4:P44,"DOWNGRADE"))

Hope this helps

M.

Worked like a charm. Many, many thanks!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.