My Countif formula is not working.

NotTheBestTool

New Member
Joined
Mar 2, 2022
Messages
16
Office Version
  1. 2016
Platform
  1. Windows
I need help with cell F109 and G109

Excel Exam - Reporting Analyst 1.xlsb
CDEFGHIJ
79Table 4 contains a project's monthly statistics for the year 2018.
80
81a. Find the quarterly and annual (2018) AHT and ASA
82b. Determine how many months the target was achieved for AHT and ASA (targets indicated below on E106:F106)
83c. Highlight values meeting the target with GREEN and values not meeting the target with RED (it can be either cell fill or icons)
84d. Using the data in Table 4, create a chart similar to the one shown on the right; place your chart below the sample
85e. Enter the monthly percentage change in terms of calls handled in the column provided then highlight the highest growth with GREEN and the highest drop with RED
86
87
88Table 4. Monthly Project Statistics 2018
89MonthQuarterCalls HandledAHTASAMonthly % Change (Calls)
90Jan 2018Q11,0230:07:030:00:32
91Feb 2018Q19230:05:370:00:43-9.78%
92Mar 2018Q19780:05:530:00:385.96%
93Apr 2018Q28630:06:590:00:50-11.76%
94May 2018Q27810:07:180:00:56-9.50%
95Jun 2018Q26980:07:120:01:47-10.63%
96Jul 2018Q37200:08:070:01:433.15%
97Aug 2018Q36310:08:450:01:57-12.36%
98Sep 2018Q37860:09:010:02:0024.56%
99Oct 2018Q47710:08:420:01:26-1.91%
100Nov 2018Q46600:08:400:01:52-14.40%
101Dec 2018Q46140:09:270:00:38-6.97%
102
103Q12,9240:06:110:00:38
104Q22,3420:07:100:01:11
105Q32,1370:08:380:01:53
106Q42,0450:08:560:01:19
107OVERALL9,4480:07:440:01:15
108TARGET ≤0:08:000:01:30
109MONTHS PASSED TARGET00
Questionnaire
Cell Formulas
RangeFormula
H91:H101H91=(E91-E90)/E90
E103:E106E103=SUMIFS(E$90:E$101, $D$90:$D$101, $D103)
F103:F106F103=AVERAGEIFS(F90:F101,D90:D101,D103)
G103:G106G103=AVERAGEIFS(G90:G101,D90:D101,D103)
E107E107=SUM(E90:E101)
F107:G107F107=AVERAGE(F103:F106)
F109F109=COUNTIF(F103:F106,"<F108")
G109G109=COUNTIF(G103:G107,"<G108")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
H91:H101Cell Valuetop 1 bottom valuestextNO
H91:H101Cell Valuetop 1 valuestextNO
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
You need to take the cell reference out of the quotes, otherwise it's being treated as text.
 
Upvote 0
You need to take the cell reference out of the quotes, otherwise it's being treated as text.
1646232508815.png

I removed the quotes and it doesnt work
 
Upvote 0
It should be strucured like this:
Excel Formula:
=COUNTIF(F103:F106,"<" & F108)
 
Upvote 0
Solution

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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