AverageIF help

I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0).

Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column.

I wrote this formula: =AVERAGEIF([Time-to-Fill (working days)]16:[Time-to-Fill (working days)]32, Department:Department = "Human Resources")

But all it's coming back with is "0". I even tried with a different Department and still "0".

Please can someone help!!

Capture for SmartSheet.PNG

Find more posts tagged with

Human Resources

Non-profit

Reports

Comments

L_123

I haven't really delved into the averageif formula yet, so here is another way to achieve the same result.

=avg(collect([Time-to-Fill (working days)]16:[Time-to-Fill (working days)]32,Department:Department, "Human Resources"))

L_123

after a quick look at the averageif documentation, the formula goes

averageif(range, criteria, return range)

Range: is the range you are checking for the criteria

Criteria: is the criteria for the previously specified range

return range: is the associated column you would like to average

AVERAGEIF(Department16:Department32, "Human Resources",Time-to-Fill (working days)]16:[Time-to-Fill (working days)]32)

Try that.

Sign in to join the conversation!

Quick Links

Trending discussions

Blank rows appearing on the bottom of Report and embedded reports
I have a report that will generally only have about 15 rows on it. I see in other threads that Smartsheet will automatically create enough blank rows to reach 50, or at least 10 blank rows always at the bottom. Even if I delete the blank rows from the Sheet (which has hundreds of data rows), they reappear the next time I…
Automating Quarterly/Annual Reminders
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!