COUNTIFS and SUMIFS functions?
I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried SUMIFS and COUNTIFS, but I cant get it right and either get invalid ref or unparseable.
- I would like to be able to count the number of stars appear for an individual (CA column).
- I would like to sum the dollar value for each person, that had a star (column not shown, but its contract values)
Best Answer
-
Hi @SadieW
Here are the formulas that you can try
- Count of starts for an individual =COUNTIFS(Priority:Priroty, 1, CA:CA, "Full name as it appears in the cell")
- Sum of contract value for an individual =SUMIFS([Contract value column]:[Contract value column], Priority:Priroty, 1, CA:CA, "Full name as it appears in the cell")
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Hi @SadieW
Here are the formulas that you can try
- Count of starts for an individual =COUNTIFS(Priority:Priroty, 1, CA:CA, "Full name as it appears in the cell")
- Sum of contract value for an individual =SUMIFS([Contract value column]:[Contract value column], Priority:Priroty, 1, CA:CA, "Full name as it appears in the cell")
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Thank you soooo much. In the logic, when you place a 1, what does that actually mean, true?
Also, if I use COUNTIFS and I want the formula to count the number of cells that are either blank or are greater than today's date, do I incorporate an OR function?
-
1 Yes, 1 means true.
2 Yes, but you use COUNTIF.
=COUNTIF(Date:Date, OR(ISBLANK(@cell), @cell > TODAY()))
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!