sum multiple criteria

  1. M

    Need to get Sum of a Column based on values satisfying criteria in 6 different columns

    I have a requirement to evaluate a sum of a single column, if 5 other columns satisfy individual criteria. Each of this columns would have array of values. Considering following subset of data DIFFERENCE_PERIOD_NET PERIOD_NET_DR PERIOD_NET_CR PERIOD_NUM SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4...
  2. S

    sum multiple criteria in multiple columns and rows

    Good day can you please help me to create a formula, for multiple criteria with multiple results in rows. explaining this problem is a bigger problem for me, i have attached an image file to explain this problem better. best regards https://www.dropbox.com/s/k3ptvj746zrudcw/untitled.JPG

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top