sum if error

  1. S

    Sum array with some criteria problem

    I have Sheet1 and Sheet2. Sheet1 <tbody> employeeID (c column) JobID (d column) result 23 1 </tbody> Sheet2 (named CSV1) <tbody> employeeID (A column) JobID (D column)) payment1 (X column) payment2 (BM column) 23 1 3334 3454 </tbody> In Result column on sheet1 I want to have sum...
    • sasa_z
    • Thread
    • column employeeid excel & formula sheet1 sum if error
    • Replies: 15
    • Forum: Excel Questions
  2. H

    =sumif not turning over properly.

    I am trying to run this simple code but once its ran, I get these unneeded (U) in th final result and get an error. Range("B2").Select ActiveCell.FormulaR1C1 = _ "=SUMIF(ertwertwertre!T:U,Sheet1!A2,ertwertwertre!U:U)" This is what the results are and I get an error...
  3. S

    Help Converting Sum If Array Formula to use INDIRECT

    Hello - I need your help. I currently have an array Sum If formula that sums data from a column in another Workbook. Each month the worksheet that the data is in changes to a new "Mmm Yy" tab in the workbook (from "Jan 16" to "Feb 16"). Because of this I would like to add the INDIRECT formula to...
  4. M

    SUM if for separate sheet

    Hi people, I a new here and i have a worksheet with several buyers in sheets. I need to hv one sheet in which i have for evry byer how much certai goods did he take. Crteria is month, type of goods. I am stuck on SUM IF formula which is giving zero or VALUE error Here is my formula...

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