How do I Write a Count if formula?
In a different sheet I want to write a formula that counts how many CDO is reliant and have a status of 5?
and a formula that counts how many CDO is AHN with a status of 5?
Thanks
Best Answer
-
This is how your first formula should look
Answers
-
Hello,
Plug each formula in and that will give you a summary for the sheet. Be sure to click "reference another sheet" in order to reference the columns.
=COUNTIFS(CDO:CDO, "AHN", Status:Status, 5)
=COUNTIFS(CDO:CDO, "Reliant", Status:Status, 5)
-
It didn't work it, it say's Unparseable
-
If you are putting these formulas in another sheet then you will need to use cross sheet references.
Here are some instructions on how to create those:
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Jeff M. @Paul Newcome I tried to reference it but no luck
-
=COUNTIFS({CDO}:{CDO},"AHN",{Status}:{Status},5)
I did this formula with cross sheet reference did I do it wrong?
-
Make sure you click here when entering the columns in the formula.
Then click the column name to select the entire column and hit insert reference at the bottom.
-
@Jeff M. =COUNTIFS({CDO}, "AHN", {Status:Status}, 5) Is it like this? I did the insert reference you mentioned still no luck?
=COUNTIFS({CDO}, "AHN", {Status:Status}, 5) is this right?
-
@Jeff M. And in the one you had above I don't see where you referenced CDO in your formula?
-
In the new sheet, create your 2 columns for summary. In the first cell, in the first column, type =COUNTIFS( Now click the "reference another sheet" in the little window that pops up and then browse your sheets and select the one you want to reference.
Once you have highlighted the column and click the insert reference button at the bottom of the screen, it should update your formula with the reference name. It should look like this but with your sheet name instead of "test sheet" =COUNTIFS({Test Sheet Range 1},
If you don't need this in another sheet, you can alternatively select the summary option in the menu that's on the right of the master sheet. Create a text/number column, then plug in the original formula without needing to reference the sheet. Then another for the next summary
-
This is how your first formula should look
-
@Jeff M. Thank you so much it worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!