COUNTIFS AND OR in MSexcel: therefore SUMPRODUCT AND OR(?)

Dee Dee

New Member
Joined
Sep 18, 2020
Messages
20
Office Version
  1. 365
Platform
  1. Windows
I am having an issue with the "old" version excel still. Each new addition to a formula seems to make things more difficult. In this case, I need to make L, M and N involve multiple criteria with AND and OR.

Formal complaint tracker a:a =<180 AND J:J="N" AND T:T="N"
OR if A:A>360 AND J:J="Y" OR T:T="Y"

This would be for L and I can figure our the other two. Again, I am having issues with my xl2bb paste. I really do not know what I am doing wrong because it had been working before.

Note:
The first few formulas I did on this file it was about 430kb, after it was returned to me for additional work it is now 45,220kb. I assume that this may be a part of the problem.


Tracker new version.xlsx
ACDEFGHIJKLMNO
1As of :Carryover from prior FYFiled in Current FYTotal (B+C)Pending AcknowledgmentPending Acceptance or DismissalAcceptedDismissedAmendedPending InvestigationInvestigation Completed TimelyInvestigation UntimelyAverage Days in InvestigationSettlement
2
3
4FY202200000000000
5FY20213362021120 1
6FY2020661263210271
7FY201900000000000
8
91
10
11
12
13
Formal Director's Update
Cell Formulas
RangeFormula
C4C4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$Z$2:$Z$3000>$A$9))
D4:D7D4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=B4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<B3))
E4:E7E4=C4+D4
F4F4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$G$2:$G$3000=""))
G4G4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000=""))
H4H4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
I4I4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000=" Dismissal"))
J4J4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="Y"))
K4K4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
L4L4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$A$2:$A$3000>=180)--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="N")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$T$2:$T$3000="N"))
C5C5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$Z$2:$Z$3000>$A$9))
F5F5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$G$2:$G$3000=""))
G5G5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000=""))
H5H5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
I5I5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Dismissal"))
J5J5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="Y"))
K5K5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
L5L5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$A$2:$A$3000>=180)--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="N")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$T$2:$T$3000="N"))
C6C6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$Z$2:$Z$3000>$A$9))
F6F6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$G$2:$G$3000=""))
G6G6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000=""))
H6H6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
I6I6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Dismissal"))
J6J6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="Y"))
K6K6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
L6L6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$A$2:$A$3000>=180)--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="N")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$T$2:$T$3000="N"))
C7C7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$Z$2:$Z$3000>$A$9))
F7F7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$G$2:$G$3000=""))
G7G7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000=""))
H7H7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
I7I7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Dismissal"))
J7J7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="Y"))
K7K7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Acceptance")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$H$2:$H$3000="Partial Dismissal"))
L7L7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$A$2:$A$3000>=180)--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$J$2:$J$3000="N")--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$T$2:$T$3000="N"))
N5N5=IFERROR(AVERAGEIFS('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!Y:Y,'C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!F:F,">=10/1/2020",'C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!F:F,"<=9/30/2021"),"")
O4O4=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$3),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$AG$2:$AG$3000="Y"))
O5O5=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$4),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$AG$2:$AG$3000="Y"))
O6O6=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$5),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$AG$2:$AG$3000="Y"))
O7O7=SUMPRODUCT(--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000>=$B$7),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$F$2:$F$3000<$B$6),--('C:\Users\deish\Downloads\[Complaints Tracker - FY21.xlsx]Formal Complaint Tracking'!$AG$2:$AG$3000="Y"))
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
If the formulas used to work OK and now have stopped working, this is surely because of the additional hidden corrupted stuff that has bloated the workbook to 45 MB.

To get that corrected is a bit of work.
Make a new workbook
Set up a sheet with the same formatting as this current sheet. Don't copy this sheet across!!

Now take one cell and rebuild the formula in here (you can copy the formula from the old workbook to the new. Don't copy the cell)
Check that it works. Then rebuild the other cells. By modifying your absolute references to semi absolute you will be able to copy down or across a lot of the formulas.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,554
Messages
5,625,474
Members
416,109
Latest member
TripleA00123

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
Top