nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

help with average formula

gjav

Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?

Find more posts tagged with

Construction

Formulas

Project Management

Comments

Paul Newcome

If you only have the criteria of excluding "INDEX DATA", you can use the AVERAGEIF function.

=AVERAGEIF([Average Column]:[Average Column], @cell <> "INDEX DATA", [Average Column]:[Average Column])

gjav

Paul thank you for trying to help but that formula didn't work. I provided a screen shot of the column I am trying to average, W/O Time Lapse column.

Paul Newcome

I am unable to see any screenshots. Could you try re-posting it?

gjav

figured it out thank you!

Sign in to join the conversation!

Quick Links

Trending discussions

not getting confirmation mail from form smartsheet
hi team for not getting quick response copy form smartsheet what are the reasons
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
Checkboxes not showing after mobile update
Just wondering if anyone else experiencing this issue? The checkbox cells would normally be an empty checkbox but update the recent mobile app update, they would disappear on any column with checkbox type, specifically on sheets and reports, dynamic views is good. This is only happening on mobile app, browser works fine.