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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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

F
  • Question Question
Scoresheet creation for a trivia game
Replies
1
Views
337
Rijnsent
Rijnsent
R
  • Question Question
Golf scoring game
Replies
4
Views
558
Rock5150
R
V
  • Question Question
Sum values in a row in ALL Columns upto the selected column
Replies
0
Views
403
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
V
  • Question Question
Excel Chat
Replies
6
Views
491
vmjan02
V

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,623
Latest member
Techenthusiast

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