Hlookup, offset, sum

K

klopchik

New Member
Joined
May 3, 2019
Messages
3
Hello all! It's my first post, so please be nice :-)

I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an offset. Help please?

[TABLE="width: 434"]
<colgroup><col width="62" span="7" style="width:47pt"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 62"] [/TD]
[TD="class: xl69, width: 62"]bob[/TD]
[TD="class: xl69, width: 62"]score[/TD]
[TD="class: xl69, width: 62"]mary[/TD]
[TD="class: xl69, width: 62"]score[/TD]
[TD="class: xl69, width: 62"]jean[/TD]
[TD="class: xl69, width: 62"]score[/TD]
[/TR]
[TR]
[TD="class: xl69"]q1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl69"]q2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl69"]q3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[/TR]
[TR]
[TD="class: xl69"]q4[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68, colspan: 3"]dashboard[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"] [/TD]
[TD="class: xl68"]q1+2[/TD]
[TD="class: xl68"]q3+4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"]bob[/TD]
[TD="class: xl68"]3[/TD]
[TD="class: xl68"]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"]mary[/TD]
[TD="class: xl68"]?[/TD]
[TD="class: xl68"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68"]jean[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Welcome to the forums.

Assuming your data set is setup like the below, then try the below formula.

B2 (copied over one column and down as many as you need):
Code: 
=IF(COLUMNS($B$2:B2)=1,SUM(SUMIFS(INDEX($F$2:$K$5,,MATCH($A2,$F$1:$K$1,0)+1),$E$2:$E$5,{"Q1","Q2"})),SUM(SUMIFS(INDEX($F$2:$K$5,,MATCH($A2,$F$1:$K$1,0)+1),$E$2:$E$5,{"Q3","Q4"})))


[TABLE="width: 704"]
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"]q1+2[/TD]
[TD="class: xl63, width: 64"]q3+4[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]Quarter[/TD]
[TD="class: xl63, width: 64"]bob[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[TD="class: xl63, width: 64"]mary[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[TD="class: xl63, width: 64"]jean[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[/TR]
[TR]
[TD="class: xl63"]bob[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD][/TD]
[TD="class: xl63"]q1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]mary[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD][/TD]
[TD="class: xl63"]q2[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]jean[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD][/TD]
[TD="class: xl63"]q3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63"]q4[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Cyrus, THANK YOU. The code of-course works perfectly in this simple example, but I'm having trouble adjusting it for the growing complexity of my data set. Let me try again, please?

I'm going to have multiple tabs of results and scores for "named" people by category. There will be 5 unchanging categories so the sum function can reference them by name (cat1, cat2) as you were doing with "Q1" and "Q2" but also sum only the scores for the "looked up" person.


[TABLE="width: 434"]
<tbody>[TR]
[TD="class: xl68, width: 62"]data set[/TD]
[TD="width: 62"][/TD]
[TD="width: 62"][/TD]
[TD="width: 62"][/TD]
[TD="width: 62"][/TD]
[TD="width: 62"][/TD]
[TD="width: 62"][/TD]
[/TR]
[TR]
[TD="class: xl70"]Category[/TD]
[TD="class: xl69"]bob[/TD]
[TD="class: xl69"]score[/TD]
[TD="class: xl69"]mary[/TD]
[TD="class: xl69"]score[/TD]
[TD="class: xl69"]jean[/TD]
[TD="class: xl69"]score[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat4[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat4[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat5[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]0[/TD]
[/TR]
[TR]
[TD="class: xl70"]cat5[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]xxx[/TD]
[TD="class: xl69"]3[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Category[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dasboard[/TD]
[TD]cat1[/TD]
[TD]cat2[/TD]
[TD]cat3[/TD]
[TD]cat4[/TD]
[TD]cat5[/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD]sum of all scores for bob for cat1[/TD]
[TD][/TD]
[TD]sum of all scores for bob for cat3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]sum of all scores for mary for cat1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jean[/TD]
[TD][/TD]
[TD][/TD]
[TD]sum of all scores for jean for cat3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



CyrusTheVirus said:
Welcome to the forums.

Assuming your data set is setup like the below, then try the below formula.

B2 (copied over one column and down as many as you need):
Code: 
=IF(COLUMNS($B$2:B2)=1,SUM(SUMIFS(INDEX($F$2:$K$5,,MATCH($A2,$F$1:$K$1,0)+1),$E$2:$E$5,{"Q1","Q2"})),SUM(SUMIFS(INDEX($F$2:$K$5,,MATCH($A2,$F$1:$K$1,0)+1),$E$2:$E$5,{"Q3","Q4"})))


[TABLE="width: 704"]
<tbody>[TR]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"]q1+2[/TD]
[TD="class: xl63, width: 64"]q3+4[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]Quarter[/TD]
[TD="class: xl63, width: 64"]bob[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[TD="class: xl63, width: 64"]mary[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[TD="class: xl63, width: 64"]jean[/TD]
[TD="class: xl63, width: 64"]score[/TD]
[/TR]
[TR]
[TD="class: xl63"]bob[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD][/TD]
[TD="class: xl63"]q1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]mary[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD][/TD]
[TD="class: xl63"]q2[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63"]jean[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD][/TD]
[TD="class: xl63"]q3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63"]q4[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"]xxx[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
 
Upvote 0
Ok, try the below. But first make your data set a 'table', do you know how to do this? Highlight the data set, and then press 'Ctrl+T'. So, as your table expands, the below formula will automatically update. You can copy/paste the below data sets into excel and then put the below formula in cell B2 and copy down/over. Reach back out with any questions.

B2 (copied down and over):
Code: 
=SUMIFS(INDEX(Table1[#Data],,MATCH($A2,Table1[#Headers],0)+1),Table1[Category],B$1)


[TABLE="width: 662"]
<tbody>[TR]
[TD]dasboard[/TD]
[TD]cat1[/TD]
[TD]cat2[/TD]
[TD]cat3[/TD]
[TD]cat4[/TD]
[TD]cat5[/TD]
[TD][/TD]
[TD]Category[/TD]
[TD]bob[/TD]
[TD]score[/TD]
[TD]mary[/TD]
[TD]score2[/TD]
[TD]jean[/TD]
[TD]score3[/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD]cat1[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]cat1[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]jean[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]cat1[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat2[/TD]
[TD]xxx[/TD]
[TD="align: right"]7[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat2[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat2[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat2[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat3[/TD]
[TD]xxx[/TD]
[TD="align: right"]7[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat4[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat4[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat5[/TD]
[TD]xxx[/TD]
[TD="align: right"]2[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[TD]xxx[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]cat5[/TD]
[TD]xxx[/TD]
[TD="align: right"]7[/TD]
[TD]xxx[/TD]
[TD="align: right"]1[/TD]
[TD]xxx[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Xlookup or Alternative?
Replies
7
Views
110
Peter_SSs
Peter_SSs
F
  • Question Question
Scoresheet creation for a trivia game
Replies
1
Views
346
Rijnsent
Rijnsent
R
  • Question Question
Golf scoring game
Replies
4
Views
579
Rock5150
R
V
  • Question Question
Sum values in a row in ALL Columns upto the selected column
Replies
0
Views
406
vikrampnz
V
J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
2K
felixstraube
F

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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