# Need some help to create a formula

##### New Member
I am trying to create a formula to help me automate a chart, what i have is a list of costs sorted by random dates, what i want to do is take all costs from each month and add them together and then have them totaled on a seperate tab.

For example i have a charge of \$100 in cell A1 on 1/3/08 in cell B1, and a charge \$50 in cell A2 on 1/30/08 in cell B2. so the formula should be something like =if(B1=1/1/08 - 1/31/08,=sum(offset... and then it gets too complicated for my brain. if this makes sense to anyone, any help would greatly be appreciated. Thanks.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Makrini

##### Well-known Member
You could try having a "helper row"

i.e in "C1" = Month(B1)

then use...

=SUMIF(C1:C100,1,A1:A100)

(The above formula for January...)

#### mgirvin

##### Well-known Member
Have you considered using a Pivot Table and Pivot Chart? If your data set has field names and is set up in Excel "List" or "Table" or "Database" format (field names at top, no blank columns, rows), it would be easy to create a Pivot Table. You would add the date field to the Row Field (2003) or Row Labels (2007), then right-click and group by month and year. Next, add the field name to the Data Items (2003) or Values area (2007). Then in 2003 click the Pivot Chart button on the Pivot Table tool bar, or in 2007 click the Pivot Chart button in the Tools group on the Options/PivotTableTools Ribbon.

##### New Member
Ok, so i think i need to clarify what im trying to do, see below for a sample of the data.

<TABLE style="TABLE-LAYOUT: fixed; WIDTH: 200pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=267 border=1><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="WIDTH: 48pt; HEIGHT: 15pt" width=64 height=20>Section</TD><TD class=xl65 style="BORDER-LEFT: medium none; WIDTH: 56pt" width=75>Date</TD><TD class=xl65 style="BORDER-LEFT: medium none; WIDTH: 48pt" width=64>Type</TD><TD class=xl65 style="BORDER-LEFT: medium none; WIDTH: 48pt" width=64>Cost</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/13/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KP</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>175</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/13/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">HD</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/13/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KV</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/20/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">A </TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>99.99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/20/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KP</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>175</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/20/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KX</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>336</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/20/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">MC</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/27/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">A </TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>99.99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/27/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">A </TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>99.99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/27/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KP</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>175</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/27/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">HD</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>12/27/2007</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KV</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">A </TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>99.99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KP</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>175</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KP</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>175</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KV</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KV</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>3400</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KV</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/10/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KC</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/17/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">VM</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>155</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/24/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">VM</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>155</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/24/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KX</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>336</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/24/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KC</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/24/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KC</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-TOP: medium none; HEIGHT: 15pt" align=right height=20>2100</TD><TD class=xl66 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>1/24/2008</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">KC</TD><TD class=xl65 style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align=right>90</TD></TR></TBODY></TABLE>

I tried to do a pivot chart but i was unable to group the dates by month, they would only list as the actual dates.

So this is a breakdown of what i need,

First i need to seperate the sections,
Second i need to group the dates by month,
Third i need to add all costs for the given month.

in the end result i would get the following
<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20> </TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right width=64>2100</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right width=64>3400</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>Dec-07</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>\$370.99</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>\$1,067.99</TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>Jan-08</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>\$1,455.99</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>\$288.00</TD></TR></TBODY></TABLE>

#### Jonmo1

##### MrExcel MVP
Welcome to the board....

Try this
Formula in G2 is
=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F2,"mmyy")),--(\$A\$2:\$A\$26=G\$1),\$D\$2:\$D\$26)
Filled down and right as needed

<CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=9><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left>Microsoft Excel - Personal.xls</TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=9><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=9><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value='=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F2,"mmyy")),--(\$A\$2:\$A\$26=G\$1),\$D\$2:\$D\$26)' selected>G2<OPTION value='=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F2,"mmyy")),--(\$A\$2:\$A\$26=H\$1),\$D\$2:\$D\$26)'>H2<OPTION value='=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F3,"mmyy")),--(\$A\$2:\$A\$26=G\$1),\$D\$2:\$D\$26)'>G3<OPTION value='=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F3,"mmyy")),--(\$A\$2:\$A\$26=H\$1),\$D\$2:\$D\$26)'>H3</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value='=SUMPRODUCT(--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F2,"mmyy")),--(\$A\$2:\$A\$26=G\$1),\$D\$2:\$D\$26)' name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>

Hope this helps

##### New Member
That is genius! Thanks!

#### mgirvin

##### Well-known Member
In a Pivot Table after you add the Date field, right-click one of the dates, point to Group, click on Year and Month, click OK, and that will group the dates.

#### mgirvin

##### Well-known Member
jonmo1,

You must tell me what the "--", Double negative does! I have seen this in a few different posts and I am curious.

#### Jonmo1

##### MrExcel MVP
converts True/False results into 1/0 results
True = 1
False = 0

Each section of formula is a TRUE or FALSE question..
--(TEXT(\$B\$2:\$B\$26,"mmyy")=TEXT(\$F2,"mmyy"))
1st, TEXT converts the Date in column B (and F2) into a Text string formatted mmyy
so the question "Is The Value in column B = F2" ? True or False

--(\$A\$2:\$A\$26=G\$1)
"Is the Value in Column A = G1" ? True or False

Sumproduct can't use True or False, so the -- changes True to 1 False to 0

Hope this helps..

#### mgirvin

##### Well-known Member
jonmo1,

How does Excel see the double negative? Does it see the "--" as a double negative (such as --1 in math would be 1, then negative 1, then back to 1); or does it see it as a string of characters that in the context of --{TRUE,TRUE,TRUE} simply says to Excel change the {TRUE,TRUE,TRUE} to {1,1,1}?

Replies
3
Views
239
Replies
1
Views
340
Replies
0
Views
291
Replies
3
Views
210
Replies
5
Views
1K

1,191,196
Messages
5,985,230
Members
439,950
Latest member
Xearo96

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

### Which adblocker are you using?

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

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