# sumifs contains

1. ### SumIfs based on Lookup table

I have two tables (examples below). I'm trying to calculate a "final score" by assesing what values were selected. I have ten total options in my real excel file that I can't share due to confidentiality constraints. table 1 (inputs) Options Selected (note the options selected below are...
2. ### Sumifs, Sumproduct or is it IF, and Sum

I am trying to create a formula that looks at results and levels and then calculates the sum of points. ACADAEAFAGAH34CompletedDoingProposed5144 Credit Points258006100max 60 @ 100 level7200min 36 @ 300 level8400max 12 @ 400...
3. ### Sumifs, Lists, and Sumproduct to create a matrix?

Hello, I am trying to create a matrix that includes specific data from different Excel workbooks. However, since I don't know how to use macros, I'm going to transfer data from each workbook to the appropriate day column in my matrix, one by one. I will use trains carrying food products as my...
4. ### Sumifs with contains

Looking for help with SUMIFS. I need the sum if Column A contains "53", "Vat" or both. <tbody> Charge Amount C5305-R-D - Duty 83,942 C5315-R-D - Gst Paid 411,816 5315-R-D - Cisf 2,985 5315-E-D - Gst Paid 233,045 153-R-D - Cisf 2,985 153-R-O - Cisf 32,410 VAT-E-D - Customs Vat...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back