sumif based on variable

  1. L

    SUMIF not working

    Hi, I have a very simple formula: =SUMIF(C49:C58,"James",A49:A58) The values in Column A are being pulled from another sheet in the same workbook and are correct. I've checked for any errors (like extra spaces) in Column C. Instead of summing my results, I keep getting 0. I tried pasting...
  2. T

    sum range with Index Match

    Hi guys! Would appreciate a help on this one. I have the fundraising amount in one column and name in another one <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 100px"><col width="129"></colgroup><tbody>...
  3. S

    Sumif Sum Range to be a reference

    Hi All, I have an indirect formula which works fine however I now need to make the SUM range dynamic as its basically summing a different date each week. <tbody> Name 06/10/16 (this date changes each week) David 8 (this is where the formula would be) </tbody> This is the formula...
  4. L

    Multiple conditions in rows (for now!) and columns (months) for SUMIFS (?)

    Hello everyone. I have written the formula as seen below and works like that: In the A6:A35 is looking for the codes that have as a 7th and 8th letters "CN" and then in the B6:B35 is looking for "Reliable". Then for the month August (j6:j35) it sums the amounts for the above criteria. What I...
  5. S

    Using WeekNum as a variable to total a sum range with a criteria range

    Thanks in advance for helping out... Excel 2013 / Win7 I would like to update the criteria in a formula which contains a criteria range based upon the value of the weeknum. The range of cells decreases as each week passes. I have one cell which is the criteria =weeknum(today()), a...

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