Sign in to join the conversation:
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?
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])
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.
I am unable to see any screenshots. Could you try re-posting it?
figured it out thank you!
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
