Excel - Sumif only in the first line of a date

A

AttAtt

New Member
Joined
Sep 16, 2018
Messages
3
hey all ,


im new here :)


i need to make sumif by date but only in the first line of the date .
if there is duplicate date dont make sum if just insert 0.
in the pic you can see in column C the result that i need

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]number[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]result[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 68"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1/2/2018[/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[/TR]
[TR]
[TD]1/4/2018[/TD]
[/TR]
[TR]
[TD]1/4/2018[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[/TR]
[TR]
[TD]1/17/2018[/TD]
[/TR]
[TR]
[TD]1/17/2018[/TD]
[/TR]
[TR]
[TD]1/19/2018[/TD]
[/TR]
[TR]
[TD]1/19/2018[/TD]
[/TR]
[TR]
[TD]1/19/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]73.48[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]139.48[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]-153.12[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]-115.78[/TD]
[/TR]
[TR]
[TD="class: xl65"]-99.18[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]240.68[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]169.6866[/TD]
[/TR]
[TR]
[TD="class: xl65"]231.4534[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]73.48[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]139.48[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]-153.12[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]-214.96[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]240.68[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]401.14[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
Hi,

Try this :

C2 =IF(B2=0,SUMIF($A$2:$A$15,A2,$B$2:$B$15),0)



[TABLE="width: 280"]
<colgroup><col width="70" span="4" style="width:52pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 70"][/TD]
[TD="class: xl63, width: 70"]A[/TD]
[TD="class: xl63, width: 70"]B[/TD]
[TD="class: xl63, width: 70"]C[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]Date[/TD]
[TD="class: xl63"]Number[/TD]
[TD="class: xl63"]Result[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[TD="class: xl64"] 1/2/2018
[/TD]
[TD="class: xl63"]
0[/TD]
[TD="class: xl63"]73.48[/TD]
[/TR]
[TR]
[TD="class: xl63"]3[/TD]
[TD="class: xl64"]1/2/2018[/TD]
[TD="class: xl63"]73.48[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]4[/TD]
[TD="class: xl64"]1/3/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]139.48[/TD]
[/TR]
[TR]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1/3/2018[/TD]
[TD="class: xl63"]139.48[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]6[/TD]
[TD="class: xl64"]1/4/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]-153.12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl64"]1/4/2018[/TD]
[TD="class: xl63"]-153.12[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]8[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]-214.96[/TD]
[/TR]
[TR]
[TD="class: xl63"]9[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]-115.78[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]10[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]-99.18[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]11[/TD]
[TD="class: xl64"]1/17/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]240.68[/TD]
[/TR]
[TR]
[TD="class: xl63"]12[/TD]
[TD="class: xl64"]1/17/2018[/TD]
[TD="class: xl63"]240.68[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]13[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]401.14[/TD]
[/TR]
[TR]
[TD="class: xl63"]14[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]169.6866[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]15[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]231.4534[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
admiral100 said:
Hi,

Try this :

C2 =IF(B2=0,SUMIF($A$2:$A$15,A2,$B$2:$B$15),0)



[TABLE="width: 280"]
<tbody>[TR]
[TD="class: xl63, width: 70"][/TD]
[TD="class: xl63, width: 70"]A[/TD]
[TD="class: xl63, width: 70"]B[/TD]
[TD="class: xl63, width: 70"]C[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]Date[/TD]
[TD="class: xl63"]Number[/TD]
[TD="class: xl63"]Result[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[TD="class: xl64"] 1/2/2018[/TD]
[TD="class: xl63"] 0[/TD]
[TD="class: xl63"]73.48[/TD]
[/TR]
[TR]
[TD="class: xl63"]3[/TD]
[TD="class: xl64"]1/2/2018[/TD]
[TD="class: xl63"]73.48[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]4[/TD]
[TD="class: xl64"]1/3/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]139.48[/TD]
[/TR]
[TR]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1/3/2018[/TD]
[TD="class: xl63"]139.48[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]6[/TD]
[TD="class: xl64"]1/4/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]-153.12[/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl64"]1/4/2018[/TD]
[TD="class: xl63"]-153.12[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]8[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]-214.96[/TD]
[/TR]
[TR]
[TD="class: xl63"]9[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]-115.78[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]10[/TD]
[TD="class: xl64"]1/5/2018[/TD]
[TD="class: xl63"]-99.18[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]11[/TD]
[TD="class: xl64"]1/17/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]240.68[/TD]
[/TR]
[TR]
[TD="class: xl63"]12[/TD]
[TD="class: xl64"]1/17/2018[/TD]
[TD="class: xl63"]240.68[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]13[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]401.14[/TD]
[/TR]
[TR]
[TD="class: xl63"]14[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]169.6866[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]15[/TD]
[TD="class: xl64"]1/19/2018[/TD]
[TD="class: xl63"]231.4534[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Hey ,
thanks for the answer ,
there is a problem in those lines :

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 132"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]8/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]8/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]8/30/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]-49.8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]-49.8[/TD]
[/TR]
[TR]
[TD="align: right"]-49.8[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

in column C i expected to get -49.8 only in the first row

Thanks
 
Upvote 0
Try this : (leave the header in column C empty)

C2 =IF(AND(B2=0,C1=0),SUMIF($A$2:$A$18,A2,$B$2:$B$18),0)

[TABLE="width: 280"]
<colgroup><col width="70" span="4" style="width:52pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 70"][/TD]
[TD="class: xl66, width: 70"]A[/TD]
[TD="class: xl66, width: 70"]B[/TD]
[TD="class: xl66, width: 70"]C[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]Date[/TD]
[TD="class: xl66"]Number[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"]2[/TD]
[TD="class: xl65, align: right"]01/02/18[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]73.48[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl65, align: right"]01/02/18[/TD]
[TD="class: xl66"]73.48[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]4[/TD]
[TD="class: xl65, align: right"]01/03/18[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]139.48[/TD]
[/TR]
[TR]
[TD="class: xl66"]5[/TD]
[TD="class: xl65, align: right"]01/03/18[/TD]
[TD="class: xl66"]139.48[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]6[/TD]
[TD="class: xl65, align: right"]01/04/18[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]-153.12[/TD]
[/TR]
[TR]
[TD="class: xl66"]7[/TD]
[TD="class: xl65, align: right"]01/04/18[/TD]
[TD="class: xl66"]-153.12[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]8[/TD]
[TD="class: xl65, align: right"]01/05/18[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]-214.96[/TD]
[/TR]
[TR]
[TD="class: xl66"]9[/TD]
[TD="class: xl65, align: right"]01/05/18[/TD]
[TD="class: xl66"]-115.78[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]10[/TD]
[TD="class: xl65, align: right"]01/05/18[/TD]
[TD="class: xl66"]-99.18[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]11[/TD]
[TD="align: left"]1/17/2018[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]240.68[/TD]
[/TR]
[TR]
[TD="class: xl66"]12[/TD]
[TD="align: left"]1/17/2018[/TD]
[TD="class: xl66"]240.68[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]13[/TD]
[TD="align: left"]1/19/2018[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]401.14[/TD]
[/TR]
[TR]
[TD="class: xl66"]14[/TD]
[TD="align: left"]1/19/2018[/TD]
[TD="class: xl66"]169.6866[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]15[/TD]
[TD="align: left"]1/19/2018[/TD]
[TD="class: xl66"]231.4534[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]16[/TD]
[TD="align: left"] 8/30/2018
[/TD]
[TD="class: xl66"]
0[/TD]
[TD="class: xl66"]-49.8[/TD]
[/TR]
[TR]
[TD="class: xl66"]17[/TD]
[TD="align: left"]8/30/2018[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]18[/TD]
[TD="align: left"]8/30/2018[/TD]
[TD="class: xl66"]-49.8 [/TD]
[TD="class: xl66"]0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi,

This will do what you want regardless of how many dates are 0 (zero) before there's a number in Column B, no need to remove Headers:


Book1
ABC
1datenumberresult
21/2/2018073.48
31/2/201873.480
41/3/20180139.48
51/3/2018139.480
61/4/20180-153.12
71/4/2018-153.120
81/5/20180-214.96
91/5/2018-115.780
101/5/2018-99.180
111/17/20180240.68
121/17/2018240.680
131/19/20180401.14
141/19/2018169.68660
151/19/2018231.45340
168/30/20180-49.8
178/30/201800
188/30/201800
198/30/2018-49.80
Sheet262
Cell Formulas
RangeFormula
C2=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$19,A2,B$2:B$19),0)


Formula copied down.
 
Upvote 0
jtakw said:
Hi,

This will do what you want regardless of how many dates are 0 (zero) before there's a number in Column B, no need to remove Headers:

ABC
datenumberresult

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]73.48[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]73.48[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1/3/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]139.48[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]1/3/2018[/TD]
[TD="align: right"]139.48[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]1/4/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-153.12[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1/4/2018[/TD]
[TD="align: right"]-153.12[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-214.96[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD="align: right"]-115.78[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD="align: right"]-99.18[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]1/17/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]240.68[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]1/17/2018[/TD]
[TD="align: right"]240.68[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]1/19/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]401.14[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]1/19/2018[/TD]
[TD="align: right"]169.6866[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]1/19/2018[/TD]
[TD="align: right"]231.4534[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]8/30/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-49.8[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]8/30/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]8/30/2018[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]8/30/2018[/TD]
[TD="align: right"]-49.8[/TD]
[TD="align: right"]0[/TD]

</tbody>
Sheet262​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$19,A2,B$2:B$19),0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Formula copied down.
Click to expand...

Thanks alot ! its Work !
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Locked
  • Question Question
Below formula which works on excel 365 only, but also need to be work on excel 2021...
Replies
1
Views
166
Fluff
Fluff
T
  • Question Question
SUMIFS not Working
Replies
3
Views
346
Peter_SSs
Peter_SSs
A
  • Locked
  • Question Question
SUMIF or SUMIFS
Replies
1
Views
434
Fluff
Fluff
M
  • Solved
Sumifs Formula not working
2
Replies
15
Views
1K
Peter_SSs
Peter_SSs
Rob_010101
  • Solved
Complicated SUMIFS/COUNTIFS Formulas Required
Replies
5
Views
685
etaf
etaf

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

Share this page

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