sumrange

  1. J

    Sum data in a range based on a column and row and an equation

    Hi I have reached the edge of my knowledge and need some assistance. I have a sheet that tracks crops and input chemicals, I need to summaries this into a table so that I can budget the cost based on the month the item is consumed. In Sheet 1. Data The first few columns are for the row...
  2. Q

    Sumifs returns 0 value for alphanumeric sumrange

    Hello All, So my data from where i want to pull the sum range contains alphanumeric values in like "GS08, GS09, GS10" The criteria1 range is the range for unique client reference nos. in cells A2:A2688. Criteria1 is to pull each inidividual client reference no. for eg. 64852345. Criteria...
  3. M

    SUMIFS with multiple sumrange

    Hi, I am looking for the best way to make a formula to sum two different columns. I have my sumrange in columun G and T. I want it to use the number in G if the cell in T is blank, if it is not blank use the value in T in the sum. Thanks in advance for your help...

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