SumIfs
I cannot figure out what my formula should be to count the total number of projects by stage and category. (gray section) I need the total number of task category's totaled by the stage of the task.
Answers
-
If you put the following formula into the cell you've got highlighted:
=COUNTIFS({Page 2 Item Range}, $Label@row, {Page 2 Status Range}, [Metric 1]$17)
where {Page 2 Item Range} references the full Item column on Page 2 and {Page 2 Status Range} references the full Status column...
you can drag-fill the formula down and then across, and it should give you the count for all the different Item/Status combinations.
This is assuming that your grey header showing the different Status options is on Row 17 of your sheet (hence the $17 in the formula).
Thanks,
James
CTO, Smarter Business Processes
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!