Forum Discussion

MarcoTorinoi's avatar
MarcoTorinoi
Copper Contributor
Mar 17, 2024
Solved

SUMIFS with OR

I have this list: Column A      Column B Austria            10 France             20 Italy                 30 China               10 USA                 40   I want to sum up all the cells  i...
Formulas and Functions
  • djclements's avatar
    djclements
    Mar 17, 2024

    MarcoTorinoi Did you see my note about pressing Ctrl+Shift+Enter? If you're not using Excel 2021, Excel for MS365 or Excel for the Web, you'll need to press Ctrl+Shift+Enter when inputting that formula. Alternatively, you can also swap out SUM with SUMPRODUCT without the need for CSE:

     

    =SUMPRODUCT(SUMIF(A:A, D2:D4, B:B))

     

    Here's a couple of screenshots using Excel 2010. Note: the curly brackets are added automatically after pressing Ctrl+Shift+Enter (do NOT type them manually)...

     

    Results (Excel 2010)

SandeepMarwal's avatar
SandeepMarwal
Brass Contributor
Mar 17, 2024

MarcoTorinoi 

Check out this formula:

 

 

=SUM(FILTER(B2:B6,ISNUMBER(FIND(A2:A6,TEXTJOIN(",",,D2:D4)))))

Resources