Sumproduct OR adding criteria to Countif, Counta and Average

W

Wkruger

New Member
Joined
Feb 19, 2010
Messages
28
I trying to convert the following formula (I, II, III) and add criteria of Name and Date to the count values of “c”

CURRENT FORMULA

I: “=COUNTIF(C2:C3100,"<=6")” versley (B) and today to last 7 days (A)
II: “=COUNTA(C2:C3100)” versley (B) and today to last 7 days (A)
III: “=AVERAGE(C2:C3100)” versley (B) and today to last 7 days (A)

Additional criteria

Date (A ): (A2:A3100<=TODAY())*(CA:A3100>=TODAY()-7))
Name (B): B2:B3100="vensley"
Count (C): Less than conditions

Sorry if I was not clear enough and appreciate any help

Thank you,
Wm…

<TABLE style="WIDTH: 261pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=346 border=0 x:str><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><TBODY><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: #003366" width=102 height=27>Date Received</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=138>Team</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=106>Grade</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Susan</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40200">22-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>William</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40220">11-Feb-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>7</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40184">6-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>0</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40185">7-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>6</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>3</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>8</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40198">20-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40203">25-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR></TBODY></TABLE>
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Sorry my friend but indeed the question is not very clear (atleast to me). But I can assure you that the answer will surely be either in SUMPRODUCT or INDEX + MATCH, depending on what exactly you want.

Can you please write down in plain words what is the output you are expecting and based on how many and what criteria.
 
Upvote 0
JRB - thank you for the info, but no response was attempt in the other forum at this time. Unless you suggest I add the link regardless
 
Upvote 0
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cwkruger%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C16%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in .5in 1.0in 45.0pt; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->
Sachin Acharya,

I hope I can add some insight. I have the same data set with 3 separate independent formulas: COUNTIF which looks at data less than criteria, Counta which counts number of occurrences and lastly the average which averages data in column C . Each one of these formulas I need to add criteria of name and last 7 days.
I: “=COUNTIF(C2:C3100,"<=6")” versley (B) and today to last 7 days (A)
II: “=COUNTA(C2:C3100)” versley (B) and today to last 7 days (A)
III: “=AVERAGE(C2:C3100)” versley (B) and today to last 7 days (A)

So I tried something with the following. <o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
“=COUNTIF((C2:C3100,"<=6"),--(a2:a3100<=TODAY())*(a2:a3100>=TODAY()-7),--(b2:b3100=”versley”))<o:p></o:p>
<o:p> </o:p>
“=COUNTA(C2:C3100), ,--(a2:a3100<=TODAY())*(a2:a3100>=TODAY()-7),--(b2:b3100=”versley”))<o:p></o:p>
<o:p> </o:p>
“=AVERAGE(C2:C3100) ,--(a2:a3100<=TODAY())*(a2:a3100>=TODAY()-7),--(b2:b3100=”versley”))<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
I have used the SUMPRODUCT in the past just not sure how to use it with the above and never used INDEX + MATCH nor am I clear on when I should use them.
<o:p>
</o:p>
Again, I hope I clear up sum hehe some.

<o:p> </o:p>
Wm…
<o:p> </o:p>
<o:p>Note, I have same question on </o:p>Excel Forum and just check and no updates :(
<o:p></o:p>
http://www.excelforum.com/excel-prog...d-average.html
 
Upvote 0
F1:

=TODAY()

F2: vensley

F3: 6

I.

Control+shift+enter, not just enter...

=SUM(IF($B$2:$B$13=F2,IF($A$2:$A$13>=F1,IF($A$2:$A$13<=F1-7,IF($C$2:$C$13<=F3,1)))))

II.

Control+shift+enter, not just enter...

=SUM(IF($B$2:$B$13=F2,IF($A$2:$A$13>=F1,IF($A$2:$A$13<=F1-7,1))))

III.

Control+shift+enter, not just enter...

=AVERAGE(IF($B$2:$B$13=F2,IF($A$2:$A$13>=F1,IF($A$2:$A$13<=F1-7,$C$2:$C$13))))
 
Upvote 0
Aladin,

I tried and rec zero as an answer. EF suggested that I check the less than equal signs and believe they are correct. I looking to see how do I attached a spreadsheet. If I can figure out how one will follow.


=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,IF(NPS!$C$2:$C$3100<=F4,1)))))
=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,IF(NPS!$C$2:$C$3100<=F3,1)))))
=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,1))))
=AVERAGE(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,NPS!$C$2:$C$3100))))

Thank you
William
 
Upvote 0
Wkruger said:
Aladin,

I tried and rec zero as an answer. EF suggested that I check the less than equal signs and believe they are correct. I looking to see how do I attached a spreadsheet. If I can figure out how one will follow.


=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,IF(NPS!$C$2:$C$3100<=F4,1)))))
=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,IF(NPS!$C$2:$C$3100<=F3,1)))))
=SUM(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,1))))
=AVERAGE(IF(NPS!$B$2:$B$3100=F2,IF(NPS!$A$2:$A$3100>=F1,IF(NPS!$A$2:$A$3100<=F1-7,NPS!$C$2:$C$3100))))

Thank you
William
Click to expand...

The best way is to post a small sample as you did in your initial post along with the desired results.
 
Upvote 0
Thank you for the insight and you save me time by not having to look. Any ideas on my formula. Did I make an error?
 
Upvote 0
Wkruger said:
Thank you for the insight and you save me time by not having to look. Any ideas on my formula. Did I make an error?
Click to expand...

You can compare youself the formulas I forwarded with the ones as you adapted them. The best thing is to check out the original formulas with suitable data.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
854
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
VBA for Web Scraping help
Replies
0
Views
608
epactheactor
E
R
  • Question
Random
Replies
1
Views
454
Fluff
Fluff

Forum statistics

Threads
1,215,563
Messages
6,125,568
Members
449,237
Latest member
Chase S

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