Need to add IF to an AVERAGEIFS formula

**DHBarkley** · 10-04-2022, 06:56 PM

Good day Forum,

I have a formula I need to add an IF function to. The formula works fine, but I need it to change the response if 0.

=AVERAGEIFS(Node_Job_Count_by_Current_State!$DD$5:$DD$11004,Node_Job_Count_by_Current_State!$M$5:$M$11004,"Hawaii",Node_Job_Count_by_Current_State!$G$5:$G$11004,"Node Split",Node_Job_Count_by_Current_State!$BF$5:$BF$11004,">="&$K$1,Node_Job_Count_by_Current_State!$BF$5:$BF$11004,"<="&$L$1)

If the response is 0.00, I need it to be 0.01. I have searched the web before coming here, but I cannot find any references to this situation.

**Sam Capricci** · 10-04-2022, 07:20 PM

offhand w/o seeing a workbook, I would guess this...
=if(AVERAGEIFS(Node_Job_Count_by_Current_State!$DD$5:$DD$11004,Node_Job_Count_by_Current_State!$M$5:$M$11004,"Hawaii",Node_Job_Count_by_Current_State!$G$5:$G$11004,"Node Split",Node_Job_Count_by_Current_State!$BF$5:$BF$11004,">="&$K$1,Node_Job_Count_by_Current_State!$BF$5:$BF$11004,"<="&$L$1)=0,.01,AVERAGEIFS(Node_Job_Count_by_Current_State!$DD$5:$DD$11004,Node_Job_Count_by_Current_State!$M$5:$M$11004,"Hawaii",Node_Job_Count_by_Current_State!$G$5:$G$11004,"Node Split",Node_Job_Count_by_Current_State!$BF$5:$BF$11004,">="&$K$1,Node_Job_Count_by_Current_State!$BF$5:$BF$11004,"<="&$L$1))

**TMS** · 10-04-2022, 07:30 PM

Or (untested) maybe:

Formula:

Please Login or Register  to view this content.

**DHBarkley** · 10-05-2022, 10:58 AM

Both work great, thank you for your assistance and time.

**TMS** · 10-05-2022, 12:00 PM

You're welcome. Thanks for the rep.

Need to add IF to an AVERAGEIFS formula

LinkBack

Thread Tools

Rate This Thread

Display

Need to add IF to an AVERAGEIFS formula

Re: Need to add IF to an AVERAGEIFS formula

Re: Need to add IF to an AVERAGEIFS formula

Re: Need to add IF to an AVERAGEIFS formula

Re: Need to add IF to an AVERAGEIFS formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] AVERAGEIFS Formula Not Functioning

AVERAGEIFS - Correct Formula or other?

[SOLVED] Help with AVERAGEIFS formula

[SOLVED] AverageIFS Formula

[SOLVED] help with averageifs formula

[SOLVED] Excel 2007 : Help (again) with AVERAGEIFS formula

Need help averageifs formula

Bookmarks

Bookmarks

Posting Permissions