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!

Formula for calculating only number in Project Status (Complete)

NMillerTX

Probably a basic formula, sorry if it is.

Need a formula for calculating only the number in Project Status (Complete).

Is there an online class I can take to wrap my head around the basics?

Thanks!

Find more posts tagged with

Comments

NMillerTX

Figured it out! Sorry. I was using SUM and not SUMIF

Andrée Starå

Hi @NMillerTX

I hope you're well and safe!

Glad you got it working! Easy to miss!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

NMillerTX

Thank you!

Is it possible to take that column formula and add it to another column formula? I've tried SUMIF & SUMIFS and can't get anything to work. I'm trying to add these first two formulas together.

Re-Released Assets

=SUM([Re-Released]1:[Re-Released]66)

Assets Complete

=SUMIF([Project Status]:[Project Status], “=Complete", [#Assets]:[#Assets])

Tried:

=SUMIF(([Project Status]:[Project Status], "Complete", [#Assets]:[#Assets])+([Re-Released]1:[Re-Released]66))

=SUMIFS(([Project Status]:[Project Status], "Complete", [#Assets]:[#Assets])+([Re-Released]1:[Re-Released]66))

=SUMIF(([Project Status]1:[Project Status]66, "Complete", [#Assets]1:[#Assets]66) + ([Re-Released]1:[Re-Released]66))

=SUMIFS(([Project Status]1:[Project Status]66, "Complete", [#Assets]1:[#Assets]66) + ([Re-Released]1:[Re-Released]66))

Sign in to join the conversation!

Quick Links

Trending discussions

Formula that looks at multiple sheets
I need assistance with creating a calculation. I have a list of people on one sheet that has their names and rate of pay. The person fills in a form and enters their hours (form is the Contractor Pay Summary sheet). I need the one sheet to look at the other and pull in the rate of pay for each user. Contractor Sheet This…
Column formula
I am working on a column formula that won't generate a syntax error due to the first-row data entries. The goal of this sheet is to document and calculate changes in counts from a one month to another. A form will be used for data entry, and I have the form set up to put new entries at the bottom. The formula in the…
Creating Project Planning Sheets from a Template, Linking to Master Sheet
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…