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...
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>...
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...
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...
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 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.