COUNTIFS Formula, Multiple Criteria
Hello!
We are trying to calculate how many days delay our projects are incurring. However we only want to count Special Conditions that have a "*" in front of it. So Special Conditions with * in front of it, summing up # of days delay in the next column. Totaling for entire column. We worked through some of the formula below but just can't seem to get it correct. Any help is appreciated!
Answers
-
Just to clarify, you want to count all of the days delayed if the day selected has an * in front? Is that right?
If that's the case I think you'll need SUMIF. Something like:
=SUMIF([Special Conditions]:[Special Conditions], CONTAINS("*", @cell), [# of Days Delay]:[# of Days Delay])
Here you're looking at the range Special Conditions to see if the cell contains an *, and if it does then look to the # of Days Delay column to find the number to include in the sum.
That should do it.
-
Hi David,
That worked for 6 out of the 7 sheets. Which to the naked eye are all set up exactly the same. The 7th sheet still pops unparseable once I put the formula in.
-
That's odd. It does look correct. Is there an extra space at the end of one of your column names?
I would try to rebuild the formula in the 7th sheet manually. So write the SUMIF( and then go click on the column Special Conditions and let it populate the true name of the column. You'll have to delete the row reference (so make [Special Conditions]7 look like [Special Conditions]:[Special Conditions]) but you'll at least know that the column names are right when you do that. I would do the same thin for the # of Days column.
After doing that does that still give you an error?
-
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Great catch @Stefan
-
Typing errors are my hobby ;-) @David Tutwiler
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
woo! thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!