Finding Average Time Excluding Zero

JoeH7745

New Member
Joined
Feb 13, 2025
Messages
9
Office Version
  1. 365
Platform
  1. Windows
I have a worksheet where i have a start and finish date and time in separate columns. I have another column that has a formula to give me the time in hours and minutes it took from start to finish. I need to average the completion time of the column W3:W412 and exclude the 0:00 times for the cells in the column that do not have data yet. I get a #DIVO/0! error each way I try it.
 

Attachments

  • Screenshot.jpg
    Screenshot.jpg
    151.7 KB · Views: 8
I cannot reproduce your result, but I don't have all of your data. You will get a #DIV/0! error if all of the times are 0:00. That is true of the data we can see, but of course we have no idea what comes after that up to row 412.

For your version of Excel the following formula is more elegant, but you may get the same error.
Excel Formula:
=AVERAGEIF(W3:W412,"<>0")
 
Upvote 0
I cannot reproduce your result, but I don't have all of your data. You will get a #DIV/0! error if all of the times are 0:00. That is true of the data we can see, but of course we have no idea what comes after that up to row 412.

For your version of Excel the following formula is more elegant, but you may get the same error.
Excel Formula:
=AVERAGEIF(W3:W412,"<>0")
 
Upvote 0
FROM ABOUT 152 TO 412 THERE IS NO DATA OR 0:00 BUT 3 TO 151 HAS TIMES RANGING FROM 0:15 TO 4:04. This formula still gices me an error
 
Upvote 0
I tried this and it returns a 0:00, I am using X3:X412 because there are times there other than 0:00
Works for me:
DANTE AMOR
WXYZAAAB
1
2TOT CSGTOT LAST
30:0000:54
40:0000:52
50:0000:13AVE CSG00:00
60:0000:22AVE COM00:35
7
Hoja1
Cell Formulas
RangeFormula
W3:W6W3=T3-U3
AA5AA5=IFERROR(AVERAGEIF(W3:W412,"<>0",W3:W412),0)
AA6AA6=IFERROR(AVERAGEIF(X3:X412,"<>0",X3:X412),0)


Check that the cells in columns W and X really have numbers.

:giggle:
 
Upvote 0
MASTER TRACKER 1.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
11st QTR LATSUPS812nd QTR LATSUPS683rd QTR LATSUPS04th QTR LATSUPS0TOTAL ANNUAL149TOTAL NOT SUPPORTED18
2INITIATED DATEDOC UICDOC #SQUADRONTMSBUNONOMENCLATURECOGNIINQTY PROJ CODEDOCUMENT STATUSDATE / TIME SENT TO ILS OR CSGDATE / TIME RECEIVED FROM ILS OR CSGDECISIONREASON CODEISSUING UNITS RICCNAL REMARKSCOMPLETION DATE/TIMEDATE SHIPPEDDATE CUSTOMER RECEIVEDALLOWANCETOTAL ILS OR CSG TIMETOTAL LATSUP TIME COMPLETION TIMEMOST LATSUP'd NIINASD MOST FREQUENTLY REQUESTING LATSUPSASD MOST FREQUENTLY SUPPORTING LATSUPS
310/1/24 10:06N443294263GA71VAQ-129EA-18GN/AN/A9B01-340-91432AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/1/24 11:00N/AN/AN/A0:000:5401-640-8454N4339AP23 - ASD LEMOORE
410/2/24 9:23N4339A4270GC59VFA-213FA-18EN/AN/A9B01-443-42151AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/2/24 10:15N/AN/AN/A0:000:52
510/7/24 14:22N443294275GA75VAQ-129EA-18GN/AN/A9B01-546-62201AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/7/24 14:35N/AN/AN/A0:000:13AVERAGE ILS CSG TIME0.00APPROVED1. Multiple AK0'sP28 - ASD FALLON
610/3/24 10:23N443214275GC67VFA-213FA-18EN/AN/A9B01-468-15231AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/3/24 10:45N/AN/AN/A0:000:22AVERAGE COMPETION TIME0.00NOT SUPPORTED2. System filled / Wholesale availableNVN - FT WORTH
710/4/24 11:40N443294275GA78VAQ-129EA-18GN/AN/A9B01-465-24496AKOBBSMSAPPROVEDNA3 - ASD IWAKUNI10/4/24 12:35N/AN/AN/A0:000:55AWT CSG3. No assets availNA3 - ASD IWAKUNI
810/8/24 12:20N4339A4276GR38VFA-106FA-18FN/AN/A9B01-454-30391AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/8/24 13:01N/AN/AN/A0:000:41AWT ILS4. SARDIP filledPJZ - ASD JACKSONVILLE
910/9/24 8:11N443294281GC28VAQ-142EA-18GN/AN/A9B01-475-65281AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/9/24 8:32N/AN/AN/A0:000:21HIGHER LEVEL REVIEW5. DOC not in system or AMCRQCZ - ASD KEY WEST
1010/9/24 8:17N443294268GT62VAQ-142EA-18GN/AN/A9B01-340-91431AK7BBSMSAPPROVEDP23 - ASD LEMOORE10/9/24 8:36N/AN/AN/A0:000:19IN REVIEW6. MOC priority overriedP23 - ASD LEMOORE
1110/9/24 11:25N443294278GT03VAQ-135EA-18GN/AN/A9B01-478-288712AK0BVSMSAPPROVEDP28 - ASD FALLON10/9/24 11:43N/AN/AN/A0:000:187. Low assets/high-demand or deployed ships/unitP29 - ASD MAYPORT
1210/9/24 11:30N529944280GP55VFC-12FA-18FN/AN/A3B01-536-70731AK0BVSMSAPPROVEDP23 - ASD LEMOORE10/9/24 12:22N/AN/AN/A0:000:528. Part repaired by SQD/FRCP56 - ASD MISAWA
1310/10/24 8:12N443294263G678VAQ-136EA-18GN/AN/A7R01-529-70731AK0BBNRPAPPROVEDNA3 - ASD IWAKUNI10/10/24 9:30N/AN/AN/A0:001:189. Alternate NIIN availPNZ - ASD NORFOLK
1410/11/24 7:36N443294260GT43VAQ-135EA-18GN/AN/A7R01-522-14571AK0BBNRPAPPROVEDP23 - ASD LEMOORE10/11/24 8:03N/AN/AN/A0:000:2710. Part inaccessible (inventory, crane, & etc.)PDZ - ASD NORTH ISLAND
1510/15/24 10:45N443294134GA28VAQ-129EA-18GN/AN/A3B01-536-70731AK0BVSMSNOT SUPPORTED7. Low assets/high-demand or deployed ships/unitHOLDING 2 ASSETS FOR DEPLOYERS, TRACKING 11 OF THIS NIIN ON CONSOLIDATED REPORT10/15/24 12:00N/AN/AN/A0:001:1511. Document CancelledP0Z - ASD OCEANA
1610/16/24 7:19N443294281G615VAQ-136EA-18GN/AN/A7R01-546-41601AK0BBNRPAPPROVEDNA3 - ASD IWAKUNI10/16/24 7:45N/AN/AN/A0:000:26PRZ - ASD PAX
1710/16/24 10:38N443294278GP10VAQ-132EA-18GN/AN/A7R01-522-64481AK0BBNRPAPPROVEDP23 - ASD LEMOORE10/16/24 10:45N/AN/AN/A0:000:07PKZ - ASD WHIDBEY
1810/17/24 11:39N4339A4289GR40VFA-106FA-18FN/AN/A9B01-454-57151AK0BBSMSNOT SUPPORTED7. Low assets/high-demand or deployed ships/unitHOLDING 2 ASSETS IN IWAKUNI FOR DEPLOYERS, 10/17/24 13:30N/AN/AN/A0:001:51P64 - CRANE
1910/17/24 11:53N443294284GL44VAQ-138EA-18GN/AN/A9B01-340-91432AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/17/24 12:35N/AN/AN/A0:000:42R2P - NIMITZ
2010/18/24 7:56N443214284GS19VFA-2FA-18EN/AN/A9B00-248-38428AK0BBSMSAPPROVEDR2A - IKE10/18/24 8:23N/AN/AN/A0:000:27R2A - IKE
2110/21/24 13:56N4339A4292GR23VFA-106FA-18FN/AN/A9B01-481-93011AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/21/24 14:00N/AN/AN/A0:000:04R2Y - TR
2210/22/24 9:44N443214290G351VX-31FA-18FN/AN/A9B01-215-55121AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/22/24 10:15N/AN/AN/A0:000:31R2Z - LINCOLN
2310/22/24 11:27N4339A4283G973SLMFA-18FN/AN/A7R01-467-52641AK0BBNRPAPPROVEDR63 - P-COLA10/22/24 12:12N/AN/AN/A0:000:45R2G - GW
2410/22/24 12:35N4339A4057G690SLMFA-18FN/AN/A7R01-531-75781AK0BBNRPAPPROVEDR2Y - TR10/22/24 12:55N/AN/AN/A0:000:20R3Q - JCS
2510/22/24 12:35N4339A4123G690SLMFA-18FN/AN/A7R01-531-75781AK0BBNRPAPPROVEDPGG - GHWB10/22/24 12:55N/AN/AN/A0:000:20RGT - HST
2610/22/24 12:35N004214289HG34VX-23FA-18FN/AN/A9B01-480-50051AK0BBSMSAPPROVEDP0Z - ASD OCEANA10/22/24 12:55N/AN/AN/A0:000:20R9C - REAGAN
2710/23/24 8:06N443214292G889NAMCE LEMOOREFA-18FN/AN/A9B01-465-243310AK0BVSMSAPPROVEDP0Z - ASD OCEANA10/23/24 9:11N/AN/AN/A0:001:05PGG - GHWB
2810/23/24 10:30N4339A4260GR36VFA-106FA-18FN/AN/A9B01-511-69911AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/23/24 10:42N/AN/AN/A0:000:12RAU - GRF
2910/23/24 12:26N004214289GH35NTPSFA-18EN/AN/A9B01-135-35481AK0BBSMSAPPROVEDP28 - ASD FALLON10/23/24 12:34N/AN/AN/A0:000:08R63 - P-COLA
FY 25 MOC CELL 1
Cell Formulas
RangeFormula
C1C1=COUNTIFS($A$2:$A$412,">=10/1/2024",$A$2:$A$412,"<=12/31/2024")
G1G1=COUNTIFS($A$2:$A$412,">=1/1/2025",$A$2:$A$412,"<=3/31/2025")
K1K1=COUNTIFS($A$2:$A$412,">=4/1/2025",$A$2:$A$412,"<=6/31/2025")
O1O1=COUNTIFS($A$2:$A$412,">=7/1/2025",$A$2:$A$412,"<=9/30/2025")
R1R1=SUM(C1+G1+K1+O1)
U1U1=COUNTIF(O3:O142, "NOT SUPPORTED")
W3:W29W3=TEXT(N3-M3,"H:mm")
X3:X29X3=TEXT(S3-A3,"H:mm")
Y3Y3=MODE.MULT(I3:I412)
Z3Z3=INDEX(B3:B412,MODE(IF((B3:B412<>"")*ISNA(MATCH(B3:B412,$B$1:$B1,0)),MATCH(B3:B412,B3:B412,0))))
AA3AA3=INDEX(Q3:Q412,MODE(IF((Q3:Q412<>"")*ISNA(MATCH(Q3:Q412,$B$1:$B1,0)),MATCH(Q3:Q412,Q3:Q412,0))))
AA5AA5=IFERROR(AVERAGEIF(W3:W412,"<>0",W3:W412),0)
AA6AA6=IFERROR(AVERAGEIF(X3:X412,"<>0",X3:X412),0)
Press CTRL+SHIFT+ENTER to enter array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
I3:I412Cell ValueduplicatestextNO
S3:V412Celldoes not contain a blank value textNO
S3:V412Cellcontains a blank value textNO
R4:R412Expression=$O4="HIGHER LEVEL REVIEW"textNO
R4:R412Expression=$O4="AWT ILS"textNO
R4:R412Expression=$O4="AWT CSG"textNO
R4:R412Expression=$O4="IN REVIEW"textNO
R4:R412Expression=$O4="NOT SUPPORTED"textNO
R4:R412Expression=$O4="APPROVED"textNO
R3,A3:Q412Expression=$O3="HIGHER LEVEL REVIEW"textNO
R3,A3:Q412Expression=$O3="AWT ILS"textNO
R3,A3:Q412Expression=$O3="AWT CSG"textNO
R3,A3:Q412Expression=$O3="IN REVIEW"textNO
R3,A3:Q412Expression=$O3="NOT SUPPORTED"textNO
R3,A3:Q412Expression=$O3="APPROVED"textNO
Cells with Data Validation
CellAllowCriteria
O3:O412List=$AC$5:$AC$10
P3:P412List=$AD$5:$AD$15
Q3:Q412List=$AE$5:$AE$29
 
Upvote 0
MASTER TRACKER 1.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
11st QTR LATSUPS812nd QTR LATSUPS683rd QTR LATSUPS04th QTR LATSUPS0TOTAL ANNUAL149TOTAL NOT SUPPORTED18
2INITIATED DATEDOC UICDOC #SQUADRONTMSBUNONOMENCLATURECOGNIINQTY PROJ CODEDOCUMENT STATUSDATE / TIME SENT TO ILS OR CSGDATE / TIME RECEIVED FROM ILS OR CSGDECISIONREASON CODEISSUING UNITS RICCNAL REMARKSCOMPLETION DATE/TIMEDATE SHIPPEDDATE CUSTOMER RECEIVEDALLOWANCETOTAL ILS OR CSG TIMETOTAL LATSUP TIME COMPLETION TIMEMOST LATSUP'd NIINASD MOST FREQUENTLY REQUESTING LATSUPSASD MOST FREQUENTLY SUPPORTING LATSUPS
310/1/24 10:06N443294263GA71VAQ-129EA-18GN/AN/A9B01-340-91432AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/1/24 11:00N/AN/AN/A0:000:5401-640-8454N4339AP23 - ASD LEMOORE
410/2/24 9:23N4339A4270GC59VFA-213FA-18EN/AN/A9B01-443-42151AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/2/24 10:15N/AN/AN/A0:000:52
510/7/24 14:22N443294275GA75VAQ-129EA-18GN/AN/A9B01-546-62201AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/7/24 14:35N/AN/AN/A0:000:13AVERAGE ILS CSG TIME0.00APPROVED1. Multiple AK0'sP28 - ASD FALLON
610/3/24 10:23N443214275GC67VFA-213FA-18EN/AN/A9B01-468-15231AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/3/24 10:45N/AN/AN/A0:000:22AVERAGE COMPETION TIME0.00NOT SUPPORTED2. System filled / Wholesale availableNVN - FT WORTH
710/4/24 11:40N443294275GA78VAQ-129EA-18GN/AN/A9B01-465-24496AKOBBSMSAPPROVEDNA3 - ASD IWAKUNI10/4/24 12:35N/AN/AN/A0:000:55AWT CSG3. No assets availNA3 - ASD IWAKUNI
810/8/24 12:20N4339A4276GR38VFA-106FA-18FN/AN/A9B01-454-30391AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/8/24 13:01N/AN/AN/A0:000:41AWT ILS4. SARDIP filledPJZ - ASD JACKSONVILLE
910/9/24 8:11N443294281GC28VAQ-142EA-18GN/AN/A9B01-475-65281AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/9/24 8:32N/AN/AN/A0:000:21HIGHER LEVEL REVIEW5. DOC not in system or AMCRQCZ - ASD KEY WEST
1010/9/24 8:17N443294268GT62VAQ-142EA-18GN/AN/A9B01-340-91431AK7BBSMSAPPROVEDP23 - ASD LEMOORE10/9/24 8:36N/AN/AN/A0:000:19IN REVIEW6. MOC priority overriedP23 - ASD LEMOORE
1110/9/24 11:25N443294278GT03VAQ-135EA-18GN/AN/A9B01-478-288712AK0BVSMSAPPROVEDP28 - ASD FALLON10/9/24 11:43N/AN/AN/A0:000:187. Low assets/high-demand or deployed ships/unitP29 - ASD MAYPORT
1210/9/24 11:30N529944280GP55VFC-12FA-18FN/AN/A3B01-536-70731AK0BVSMSAPPROVEDP23 - ASD LEMOORE10/9/24 12:22N/AN/AN/A0:000:528. Part repaired by SQD/FRCP56 - ASD MISAWA
1310/10/24 8:12N443294263G678VAQ-136EA-18GN/AN/A7R01-529-70731AK0BBNRPAPPROVEDNA3 - ASD IWAKUNI10/10/24 9:30N/AN/AN/A0:001:189. Alternate NIIN availPNZ - ASD NORFOLK
1410/11/24 7:36N443294260GT43VAQ-135EA-18GN/AN/A7R01-522-14571AK0BBNRPAPPROVEDP23 - ASD LEMOORE10/11/24 8:03N/AN/AN/A0:000:2710. Part inaccessible (inventory, crane, & etc.)PDZ - ASD NORTH ISLAND
1510/15/24 10:45N443294134GA28VAQ-129EA-18GN/AN/A3B01-536-70731AK0BVSMSNOT SUPPORTED7. Low assets/high-demand or deployed ships/unitHOLDING 2 ASSETS FOR DEPLOYERS, TRACKING 11 OF THIS NIIN ON CONSOLIDATED REPORT10/15/24 12:00N/AN/AN/A0:001:1511. Document CancelledP0Z - ASD OCEANA
1610/16/24 7:19N443294281G615VAQ-136EA-18GN/AN/A7R01-546-41601AK0BBNRPAPPROVEDNA3 - ASD IWAKUNI10/16/24 7:45N/AN/AN/A0:000:26PRZ - ASD PAX
1710/16/24 10:38N443294278GP10VAQ-132EA-18GN/AN/A7R01-522-64481AK0BBNRPAPPROVEDP23 - ASD LEMOORE10/16/24 10:45N/AN/AN/A0:000:07PKZ - ASD WHIDBEY
1810/17/24 11:39N4339A4289GR40VFA-106FA-18FN/AN/A9B01-454-57151AK0BBSMSNOT SUPPORTED7. Low assets/high-demand or deployed ships/unitHOLDING 2 ASSETS IN IWAKUNI FOR DEPLOYERS, 10/17/24 13:30N/AN/AN/A0:001:51P64 - CRANE
1910/17/24 11:53N443294284GL44VAQ-138EA-18GN/AN/A9B01-340-91432AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/17/24 12:35N/AN/AN/A0:000:42R2P - NIMITZ
2010/18/24 7:56N443214284GS19VFA-2FA-18EN/AN/A9B00-248-38428AK0BBSMSAPPROVEDR2A - IKE10/18/24 8:23N/AN/AN/A0:000:27R2A - IKE
2110/21/24 13:56N4339A4292GR23VFA-106FA-18FN/AN/A9B01-481-93011AK0BBSMSAPPROVEDP23 - ASD LEMOORE10/21/24 14:00N/AN/AN/A0:000:04R2Y - TR
2210/22/24 9:44N443214290G351VX-31FA-18FN/AN/A9B01-215-55121AK0BBSMSAPPROVEDNA3 - ASD IWAKUNI10/22/24 10:15N/AN/AN/A0:000:31R2Z - LINCOLN
2310/22/24 11:27N4339A4283G973SLMFA-18FN/AN/A7R01-467-52641AK0BBNRPAPPROVEDR63 - P-COLA10/22/24 12:12N/AN/AN/A0:000:45R2G - GW
2410/22/24 12:35N4339A4057G690SLMFA-18FN/AN/A7R01-531-75781AK0BBNRPAPPROVEDR2Y - TR10/22/24 12:55N/AN/AN/A0:000:20R3Q - JCS
2510/22/24 12:35N4339A4123G690SLMFA-18FN/AN/A7R01-531-75781AK0BBNRPAPPROVEDPGG - GHWB10/22/24 12:55N/AN/AN/A0:000:20RGT - HST
2610/22/24 12:35N004214289HG34VX-23FA-18FN/AN/A9B01-480-50051AK0BBSMSAPPROVEDP0Z - ASD OCEANA10/22/24 12:55N/AN/AN/A0:000:20R9C - REAGAN
2710/23/24 8:06N443214292G889NAMCE LEMOOREFA-18FN/AN/A9B01-465-243310AK0BVSMSAPPROVEDP0Z - ASD OCEANA10/23/24 9:11N/AN/AN/A0:001:05PGG - GHWB
2810/23/24 10:30N4339A4260GR36VFA-106FA-18FN/AN/A9B01-511-69911AK0BBSMSAPPROVEDPKZ - ASD WHIDBEY10/23/24 10:42N/AN/AN/A0:000:12RAU - GRF
2910/23/24 12:26N004214289GH35NTPSFA-18EN/AN/A9B01-135-35481AK0BBSMSAPPROVEDP28 - ASD FALLON10/23/24 12:34N/AN/AN/A0:000:08R63 - P-COLA
FY 25 MOC CELL 1
Cell Formulas
RangeFormula
C1C1=COUNTIFS($A$2:$A$412,">=10/1/2024",$A$2:$A$412,"<=12/31/2024")
G1G1=COUNTIFS($A$2:$A$412,">=1/1/2025",$A$2:$A$412,"<=3/31/2025")
K1K1=COUNTIFS($A$2:$A$412,">=4/1/2025",$A$2:$A$412,"<=6/31/2025")
O1O1=COUNTIFS($A$2:$A$412,">=7/1/2025",$A$2:$A$412,"<=9/30/2025")
R1R1=SUM(C1+G1+K1+O1)
U1U1=COUNTIF(O3:O142, "NOT SUPPORTED")
W3:W29W3=TEXT(N3-M3,"H:mm")
X3:X29X3=TEXT(S3-A3,"H:mm")
Y3Y3=MODE.MULT(I3:I412)
Z3Z3=INDEX(B3:B412,MODE(IF((B3:B412<>"")*ISNA(MATCH(B3:B412,$B$1:$B1,0)),MATCH(B3:B412,B3:B412,0))))
AA3AA3=INDEX(Q3:Q412,MODE(IF((Q3:Q412<>"")*ISNA(MATCH(Q3:Q412,$B$1:$B1,0)),MATCH(Q3:Q412,Q3:Q412,0))))
AA5AA5=IFERROR(AVERAGEIF(W3:W412,"<>0",W3:W412),0)
AA6AA6=IFERROR(AVERAGEIF(X3:X412,"<>0",X3:X412),0)
Press CTRL+SHIFT+ENTER to enter array formulas.
Cells with Conditional Formatting
CellConditionCell FormatStop If True
I3:I412Cell ValueduplicatestextNO
S3:V412Celldoes not contain a blank value textNO
S3:V412Cellcontains a blank value textNO
R4:R412Expression=$O4="HIGHER LEVEL REVIEW"textNO
R4:R412Expression=$O4="AWT ILS"textNO
R4:R412Expression=$O4="AWT CSG"textNO
R4:R412Expression=$O4="IN REVIEW"textNO
R4:R412Expression=$O4="NOT SUPPORTED"textNO
R4:R412Expression=$O4="APPROVED"textNO
R3,A3:Q412Expression=$O3="HIGHER LEVEL REVIEW"textNO
R3,A3:Q412Expression=$O3="AWT ILS"textNO
R3,A3:Q412Expression=$O3="AWT CSG"textNO
R3,A3:Q412Expression=$O3="IN REVIEW"textNO
R3,A3:Q412Expression=$O3="NOT SUPPORTED"textNO
R3,A3:Q412Expression=$O3="APPROVED"textNO
Cells with Data Validation
CellAllowCriteria
O3:O412List=$AC$5:$AC$10
P3:P412List=$AD$5:$AD$15
Q3:Q412List=$AE$5:$AE$29
[/RAN
Cells with Data Validation
CellAllowCriteria
 
Upvote 0
I figured it out! I had a mistake in the cells counting time which threw off the average formula! Thank you for your help!
 
Upvote 0
Solution

Forum statistics

Threads
1,226,771
Messages
6,192,924
Members
453,767
Latest member
922aloose

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